/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * ExAlumno.java
 *
 * Created on 13/07/2012, 03:23:28 PM
 */
package Interfaz;


import Negocio.Cargo;
import Negocio.Conexion;
import Negocio.Empresa;
import Negocio.Encuesta;
import Negocio.Exalumno;
import Negocio.Persona;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Vector;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

/**
 *
 * @author Maria
 */
public class InterfazExAlumno extends javax.swing.JFrame {

    /** Creates new form ExAlumno */
    //String cedula;
    
    public String cedulaActual;
    public InterfazExAlumno() throws SQLException {
        initComponents();
        this.setLocationRelativeTo(null);
        this.cmdBuscar.setVisible(false);
      
            //Principal dato = new Principal();
           // ingresarInfoContacto();
       
        
    }

    ArrayList<String> telefonos = new ArrayList();
    ArrayList<String> correos = new ArrayList();
    int bandUsuario=0;
   

    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        jScrollPane1 = new javax.swing.JScrollPane();
        jList1 = new javax.swing.JList();
        fechaFinalizacion = new javax.swing.JDialog();
        jLabel11 = new javax.swing.JLabel();
        jLabel12 = new javax.swing.JLabel();
        jLabel32 = new javax.swing.JLabel();
        jLabel33 = new javax.swing.JLabel();
        txtDia = new javax.swing.JTextField();
        txtMes = new javax.swing.JTextField();
        txtAnioFin = new javax.swing.JTextField();
        cmdIngresarFecha = new javax.swing.JButton();
        jButton34 = new javax.swing.JButton();
        agregarTrabajo = new javax.swing.JDialog();
        jLabel34 = new javax.swing.JLabel();
        jLabel36 = new javax.swing.JLabel();
        jLabel37 = new javax.swing.JLabel();
        jLabel42 = new javax.swing.JLabel();
        txtDia1 = new javax.swing.JTextField();
        txtMes1 = new javax.swing.JTextField();
        txtAnio1 = new javax.swing.JTextField();
        cmdIngresarTrabajo = new javax.swing.JButton();
        jLabel43 = new javax.swing.JLabel();
        jLabel44 = new javax.swing.JLabel();
        cbxEmpresa = new javax.swing.JComboBox();
        cmdAEmpresa = new javax.swing.JButton();
        jLabel46 = new javax.swing.JLabel();
        cbxCargo = new javax.swing.JComboBox();
        cmdACargo = new javax.swing.JButton();
        jLabel48 = new javax.swing.JLabel();
        txtDescripcion = new javax.swing.JTextField();
        jButton33 = new javax.swing.JButton();
        jButton1 = new javax.swing.JButton();
        agregarEmpresa = new javax.swing.JDialog();
        jLabel50 = new javax.swing.JLabel();
        cmdIngresarEmpresa = new javax.swing.JButton();
        txtAEmpresa = new javax.swing.JTextField();
        jLabel55 = new javax.swing.JLabel();
        jButton32 = new javax.swing.JButton();
        agregarCargo = new javax.swing.JDialog();
        jLabel51 = new javax.swing.JLabel();
        cmdIngresarCargo = new javax.swing.JButton();
        txtACargo = new javax.swing.JTextField();
        jLabel56 = new javax.swing.JLabel();
        jButton31 = new javax.swing.JButton();
        cambiarInstitucion = new javax.swing.JDialog();
        jLabel52 = new javax.swing.JLabel();
        jLabel57 = new javax.swing.JLabel();
        cbxColegio = new javax.swing.JComboBox();
        cmdAgregarColegio = new javax.swing.JButton();
        jButton4 = new javax.swing.JButton();
        jLabel60 = new javax.swing.JLabel();
        cbxPromedioC = new javax.swing.JComboBox();
        jButton30 = new javax.swing.JButton();
        agregarColegio = new javax.swing.JDialog();
        jLabel53 = new javax.swing.JLabel();
        txtAColegio = new javax.swing.JTextField();
        jLabel58 = new javax.swing.JLabel();
        jButton3 = new javax.swing.JButton();
        jButton29 = new javax.swing.JButton();
        cambiarGenero = new javax.swing.JDialog();
        jLabel20 = new javax.swing.JLabel();
        jLabel21 = new javax.swing.JLabel();
        cbxGenero = new javax.swing.JComboBox();
        jButton10 = new javax.swing.JButton();
        jButton27 = new javax.swing.JButton();
        cambiarNacionalidad = new javax.swing.JDialog();
        jLabel22 = new javax.swing.JLabel();
        jLabel23 = new javax.swing.JLabel();
        cbxNacionalidad = new javax.swing.JComboBox();
        jButton11 = new javax.swing.JButton();
        jButton12 = new javax.swing.JButton();
        txtANacionalidad = new javax.swing.JTextField();
        jButton26 = new javax.swing.JButton();
        cambiarEtnia = new javax.swing.JDialog();
        jLabel24 = new javax.swing.JLabel();
        jLabel26 = new javax.swing.JLabel();
        cbxEtnia = new javax.swing.JComboBox();
        jButton13 = new javax.swing.JButton();
        jButton14 = new javax.swing.JButton();
        txtAEtnia = new javax.swing.JTextField();
        jButton25 = new javax.swing.JButton();
        cambiarCiudad = new javax.swing.JDialog();
        jLabel63 = new javax.swing.JLabel();
        jLabel64 = new javax.swing.JLabel();
        cmbCiudad = new javax.swing.JComboBox();
        txtACiudad = new javax.swing.JTextField();
        jButton22 = new javax.swing.JButton();
        jButton23 = new javax.swing.JButton();
        jButton24 = new javax.swing.JButton();
        editarUniversidad = new javax.swing.JDialog();
        jLabel54 = new javax.swing.JLabel();
        jLabel59 = new javax.swing.JLabel();
        jLabel65 = new javax.swing.JLabel();
        jLabel66 = new javax.swing.JLabel();
        txtAnioGraduacion = new javax.swing.JTextField();
        jLabel67 = new javax.swing.JLabel();
        bEditar = new javax.swing.JButton();
        jButton28 = new javax.swing.JButton();
        cbxFacultad = new javax.swing.JComboBox();
        cbxEscuela = new javax.swing.JComboBox();
        cbxPromedioU = new javax.swing.JComboBox();
        cbxTitulo = new javax.swing.JComboBox();
        bGuardar = new javax.swing.JButton();
        jTabbedPane1 = new javax.swing.JTabbedPane();
        jPanel1 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        txtNombres = new javax.swing.JTextField();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        txtApellidos = new javax.swing.JTextField();
        jLabel5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        txtDireccion = new javax.swing.JTextField();
        cmdLlamarEncuesta = new javax.swing.JButton();
        jLabel4 = new javax.swing.JLabel();
        jLabel8 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        txtCedula = new javax.swing.JTextField();
        jScrollPane3 = new javax.swing.JScrollPane();
        tablaTelefonos = new javax.swing.JTable();
        txtGenero = new javax.swing.JTextField();
        txtNacionalidad = new javax.swing.JTextField();
        txtRaza = new javax.swing.JTextField();
        jLabel7 = new javax.swing.JLabel();
        jScrollPane5 = new javax.swing.JScrollPane();
        tablaCorreos = new javax.swing.JTable();
        txttelefono = new javax.swing.JTextField();
        txtcorreo = new javax.swing.JTextField();
        cmdAgregarT = new javax.swing.JButton();
        cmdeliminarT = new javax.swing.JButton();
        cmdAgregarC = new javax.swing.JButton();
        cmdeliminarC = new javax.swing.JButton();
        cmdBuscar = new javax.swing.JButton();
        jButton7 = new javax.swing.JButton();
        jButton8 = new javax.swing.JButton();
        jButton9 = new javax.swing.JButton();
        jButton17 = new javax.swing.JButton();
        jLabel27 = new javax.swing.JLabel();
        txtTPrincipal = new javax.swing.JTextField();
        jLabel28 = new javax.swing.JLabel();
        txtCPrincipal = new javax.swing.JTextField();
        jButton18 = new javax.swing.JButton();
        jButton19 = new javax.swing.JButton();
        jLabel61 = new javax.swing.JLabel();
        jLabel62 = new javax.swing.JLabel();
        txtCiudad = new javax.swing.JTextField();
        jButton16 = new javax.swing.JButton();
        txtContraseña = new javax.swing.JTextField();
        jPanel4 = new javax.swing.JPanel();
        jLabel38 = new javax.swing.JLabel();
        jScrollPane2 = new javax.swing.JScrollPane();
        tablaTrabajoActual = new javax.swing.JTable();
        jLabel39 = new javax.swing.JLabel();
        jScrollPane4 = new javax.swing.JScrollPane();
        tablaHistorialTrabajo = new javax.swing.JTable();
        cmdFinalizar = new javax.swing.JButton();
        cmdAgregar = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jPanel2 = new javax.swing.JPanel();
        jLabel13 = new javax.swing.JLabel();
        jLabel14 = new javax.swing.JLabel();
        txtContacto = new javax.swing.JTextField();
        txtTipo = new javax.swing.JTextField();
        jButton15 = new javax.swing.JButton();
        cmdConfTipo = new javax.swing.JButton();
        cbxTipoContacto = new javax.swing.JComboBox();
        jLabel29 = new javax.swing.JLabel();
        jLabel30 = new javax.swing.JLabel();
        txttelefono1 = new javax.swing.JTextField();
        jScrollPane12 = new javax.swing.JScrollPane();
        tablaTelefonos1 = new javax.swing.JTable();
        txtTPrincipal1 = new javax.swing.JTextField();
        jButton20 = new javax.swing.JButton();
        jLabel45 = new javax.swing.JLabel();
        jLabel47 = new javax.swing.JLabel();
        txtCPrincipal1 = new javax.swing.JTextField();
        jButton21 = new javax.swing.JButton();
        jScrollPane13 = new javax.swing.JScrollPane();
        tablaCorreos1 = new javax.swing.JTable();
        txtcorreo1 = new javax.swing.JTextField();
        cmdeliminarC1 = new javax.swing.JButton();
        cmdAgregarC1 = new javax.swing.JButton();
        cmdeliminarT1 = new javax.swing.JButton();
        cmdAgregarT1 = new javax.swing.JButton();
        jLabel49 = new javax.swing.JLabel();
        txtOtro = new javax.swing.JTextField();
        jPanel3 = new javax.swing.JPanel();
        jLabel15 = new javax.swing.JLabel();
        jLabel16 = new javax.swing.JLabel();
        txtInstitucion = new javax.swing.JTextField();
        jLabel17 = new javax.swing.JLabel();
        txtPromedioI = new javax.swing.JTextField();
        jSeparator1 = new javax.swing.JSeparator();
        jLabel18 = new javax.swing.JLabel();
        jLabel19 = new javax.swing.JLabel();
        jLabel25 = new javax.swing.JLabel();
        jSeparator2 = new javax.swing.JSeparator();
        jLabel31 = new javax.swing.JLabel();
        jSeparator3 = new javax.swing.JSeparator();
        jLabel35 = new javax.swing.JLabel();
        jScrollPane6 = new javax.swing.JScrollPane();
        tablaTitulosUCuenca = new javax.swing.JTable();
        jScrollPane7 = new javax.swing.JScrollPane();
        tablaRepresentante = new javax.swing.JTable();
        jLabel10 = new javax.swing.JLabel();
        jTextField3 = new javax.swing.JTextField();
        cmdeditarSecundarios = new javax.swing.JButton();
        jScrollPane10 = new javax.swing.JScrollPane();
        tablaEstudiosAvanzados1 = new javax.swing.JTable();
        jScrollPane11 = new javax.swing.JScrollPane();
        tablaTitulosUniversidades = new javax.swing.JTable();
        jButton35 = new javax.swing.JButton();
        jButton36 = new javax.swing.JButton();
        jButton5 = new javax.swing.JButton();
        cbxRepresentante = new javax.swing.JComboBox();
        jButton6 = new javax.swing.JButton();
        jPanel5 = new javax.swing.JPanel();
        jLabel40 = new javax.swing.JLabel();
        jScrollPane8 = new javax.swing.JScrollPane();
        tablaEncuestas = new javax.swing.JTable();
        jLabel41 = new javax.swing.JLabel();
        jScrollPane9 = new javax.swing.JScrollPane();
        tablaEncuestasLLenar = new javax.swing.JTable();
        cmdcerrarExalumno = new javax.swing.JButton();
        lblUsuario = new javax.swing.JLabel();

        jList1.setModel(new javax.swing.AbstractListModel() {
            String[] strings = { "Item 1", "Item 2", "Item 3", "Item 4", "Item 5" };
            public int getSize() { return strings.length; }
            public Object getElementAt(int i) { return strings[i]; }
        });
        jScrollPane1.setViewportView(jList1);

        jLabel11.setText("Día:");

        jLabel12.setText("Ingrese la fecha de finalización:");

        jLabel32.setText("Mes:");

        jLabel33.setText("Año:");

        cmdIngresarFecha.setText("Ingresar Fecha");
        cmdIngresarFecha.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdIngresarFechaActionPerformed(evt);
            }
        });

        jButton34.setText("Cancelar");
        jButton34.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton34ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout fechaFinalizacionLayout = new javax.swing.GroupLayout(fechaFinalizacion.getContentPane());
        fechaFinalizacion.getContentPane().setLayout(fechaFinalizacionLayout);
        fechaFinalizacionLayout.setHorizontalGroup(
            fechaFinalizacionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(fechaFinalizacionLayout.createSequentialGroup()
                .addGroup(fechaFinalizacionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(fechaFinalizacionLayout.createSequentialGroup()
                        .addGap(66, 66, 66)
                        .addGroup(fechaFinalizacionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                            .addComponent(jLabel12)
                            .addGroup(fechaFinalizacionLayout.createSequentialGroup()
                                .addGroup(fechaFinalizacionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(jLabel11)
                                    .addComponent(jLabel32)
                                    .addComponent(jLabel33))
                                .addGap(47, 47, 47)
                                .addGroup(fechaFinalizacionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(txtAnioFin, javax.swing.GroupLayout.DEFAULT_SIZE, 82, Short.MAX_VALUE)
                                    .addComponent(txtMes, javax.swing.GroupLayout.DEFAULT_SIZE, 82, Short.MAX_VALUE)
                                    .addComponent(txtDia)))))
                    .addGroup(fechaFinalizacionLayout.createSequentialGroup()
                        .addGap(40, 40, 40)
                        .addComponent(cmdIngresarFecha)
                        .addGap(18, 18, 18)
                        .addComponent(jButton34)))
                .addContainerGap(162, Short.MAX_VALUE))
        );
        fechaFinalizacionLayout.setVerticalGroup(
            fechaFinalizacionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(fechaFinalizacionLayout.createSequentialGroup()
                .addGap(48, 48, 48)
                .addComponent(jLabel12)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(fechaFinalizacionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel11)
                    .addComponent(txtDia, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(fechaFinalizacionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel32)
                    .addGroup(fechaFinalizacionLayout.createSequentialGroup()
                        .addComponent(txtMes, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(18, 18, 18)
                        .addGroup(fechaFinalizacionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(txtAnioFin, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jLabel33))))
                .addGap(28, 28, 28)
                .addGroup(fechaFinalizacionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cmdIngresarFecha)
                    .addComponent(jButton34))
                .addContainerGap(80, Short.MAX_VALUE))
        );

        jLabel34.setText("Día:");

        jLabel36.setFont(new java.awt.Font("Tahoma", 1, 11));
        jLabel36.setText("Ingrese los campos del nuevo trabajo:");

        jLabel37.setText("Mes:");

        jLabel42.setText("Año:");

        cmdIngresarTrabajo.setText("Ingresar Trabajo");
        cmdIngresarTrabajo.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdIngresarTrabajoActionPerformed(evt);
            }
        });

        jLabel43.setText("Ingrese la fecha de inicio:");

        jLabel44.setText("Empresa:");

        cbxEmpresa.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        cmdAEmpresa.setText("Agregar Empresa");
        cmdAEmpresa.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdAEmpresaActionPerformed(evt);
            }
        });

        jLabel46.setText("Cargo:");

        cbxCargo.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        cmdACargo.setText("Agregar Cargo");
        cmdACargo.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdACargoActionPerformed(evt);
            }
        });

        jLabel48.setText("Descripción:");

        jButton33.setText("Cancelar");
        jButton33.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton33ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout agregarTrabajoLayout = new javax.swing.GroupLayout(agregarTrabajo.getContentPane());
        agregarTrabajo.getContentPane().setLayout(agregarTrabajoLayout);
        agregarTrabajoLayout.setHorizontalGroup(
            agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(agregarTrabajoLayout.createSequentialGroup()
                .addGap(66, 66, 66)
                .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel36)
                    .addGroup(agregarTrabajoLayout.createSequentialGroup()
                        .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(agregarTrabajoLayout.createSequentialGroup()
                                .addGap(12, 12, 12)
                                .addComponent(jLabel48)
                                .addGap(18, 18, 18))
                            .addComponent(jLabel44)
                            .addComponent(jLabel46))
                        .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(agregarTrabajoLayout.createSequentialGroup()
                                .addGap(36, 36, 36)
                                .addComponent(cmdAEmpresa))
                            .addGroup(agregarTrabajoLayout.createSequentialGroup()
                                .addGap(20, 20, 20)
                                .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(cbxCargo, 0, 244, Short.MAX_VALUE)
                                    .addComponent(cbxEmpresa, javax.swing.GroupLayout.PREFERRED_SIZE, 244, javax.swing.GroupLayout.PREFERRED_SIZE))))))
                .addContainerGap(26, Short.MAX_VALUE))
            .addGroup(agregarTrabajoLayout.createSequentialGroup()
                .addGap(41, 41, 41)
                .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel42)
                    .addGroup(agregarTrabajoLayout.createSequentialGroup()
                        .addComponent(jLabel34)
                        .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(agregarTrabajoLayout.createSequentialGroup()
                                .addGap(53, 53, 53)
                                .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addGroup(agregarTrabajoLayout.createSequentialGroup()
                                        .addGap(62, 62, 62)
                                        .addComponent(txtDescripcion, javax.swing.GroupLayout.DEFAULT_SIZE, 198, Short.MAX_VALUE))
                                    .addComponent(jLabel43)))
                            .addGroup(agregarTrabajoLayout.createSequentialGroup()
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                    .addComponent(cmdIngresarTrabajo)
                                    .addGroup(agregarTrabajoLayout.createSequentialGroup()
                                        .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                                            .addComponent(txtAnio1, javax.swing.GroupLayout.Alignment.LEADING)
                                            .addComponent(txtDia1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, 91, javax.swing.GroupLayout.PREFERRED_SIZE))
                                        .addGap(18, 18, 18)
                                        .addComponent(jLabel37)))
                                .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addGroup(agregarTrabajoLayout.createSequentialGroup()
                                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                        .addComponent(txtMes1, javax.swing.GroupLayout.DEFAULT_SIZE, 161, Short.MAX_VALUE))
                                    .addGroup(agregarTrabajoLayout.createSequentialGroup()
                                        .addGap(29, 29, 29)
                                        .addComponent(jButton33)))))))
                .addGap(71, 71, 71))
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, agregarTrabajoLayout.createSequentialGroup()
                .addContainerGap(199, Short.MAX_VALUE)
                .addComponent(cmdACargo)
                .addGap(142, 142, 142))
        );
        agregarTrabajoLayout.setVerticalGroup(
            agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, agregarTrabajoLayout.createSequentialGroup()
                .addGap(48, 48, 48)
                .addComponent(jLabel36)
                .addGap(18, 18, 18)
                .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel44)
                    .addComponent(cbxEmpresa, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(27, 27, 27)
                .addComponent(cmdAEmpresa)
                .addGap(27, 27, 27)
                .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel46)
                    .addComponent(cbxCargo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(30, 30, 30)
                .addComponent(cmdACargo)
                .addGap(18, 18, 18)
                .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtDescripcion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel48))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 22, Short.MAX_VALUE)
                .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel34)
                        .addComponent(txtDia1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel37)
                        .addComponent(txtMes1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(agregarTrabajoLayout.createSequentialGroup()
                        .addComponent(jLabel43)
                        .addGap(38, 38, 38)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel42)
                    .addComponent(txtAnio1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(agregarTrabajoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cmdIngresarTrabajo)
                    .addComponent(jButton33))
                .addGap(38, 38, 38))
        );

        jButton1.setText("jButton1");

        jLabel50.setFont(new java.awt.Font("Tahoma", 1, 11));
        jLabel50.setText("Ingrese el nombre de la nueva empresa:");

        cmdIngresarEmpresa.setText("Ingresar");
        cmdIngresarEmpresa.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdIngresarEmpresaActionPerformed(evt);
            }
        });

        jLabel55.setText("Agregar Empresa:");

        jButton32.setText("Cancelar");
        jButton32.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton32ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout agregarEmpresaLayout = new javax.swing.GroupLayout(agregarEmpresa.getContentPane());
        agregarEmpresa.getContentPane().setLayout(agregarEmpresaLayout);
        agregarEmpresaLayout.setHorizontalGroup(
            agregarEmpresaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(agregarEmpresaLayout.createSequentialGroup()
                .addGroup(agregarEmpresaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(agregarEmpresaLayout.createSequentialGroup()
                        .addGap(57, 57, 57)
                        .addComponent(jLabel55))
                    .addGroup(agregarEmpresaLayout.createSequentialGroup()
                        .addGap(66, 66, 66)
                        .addGroup(agregarEmpresaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(agregarEmpresaLayout.createSequentialGroup()
                                .addGap(105, 105, 105)
                                .addComponent(txtAEmpresa, javax.swing.GroupLayout.PREFERRED_SIZE, 134, javax.swing.GroupLayout.PREFERRED_SIZE))
                            .addComponent(jLabel50)))
                    .addGroup(agregarEmpresaLayout.createSequentialGroup()
                        .addGap(88, 88, 88)
                        .addComponent(cmdIngresarEmpresa)
                        .addGap(32, 32, 32)
                        .addComponent(jButton32)))
                .addContainerGap(80, Short.MAX_VALUE))
        );
        agregarEmpresaLayout.setVerticalGroup(
            agregarEmpresaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(agregarEmpresaLayout.createSequentialGroup()
                .addGap(48, 48, 48)
                .addComponent(jLabel50)
                .addGap(18, 18, 18)
                .addGroup(agregarEmpresaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel55)
                    .addComponent(txtAEmpresa, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(33, 33, 33)
                .addGroup(agregarEmpresaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cmdIngresarEmpresa)
                    .addComponent(jButton32))
                .addContainerGap(60, Short.MAX_VALUE))
        );

        jLabel51.setFont(new java.awt.Font("Tahoma", 1, 11));
        jLabel51.setText("Ingrese el nombre del nuevo cargo:");

        cmdIngresarCargo.setText("Ingresar");
        cmdIngresarCargo.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdIngresarCargoActionPerformed(evt);
            }
        });

        jLabel56.setText("Agregar Cargo:");

        jButton31.setText("Cancelar");
        jButton31.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton31ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout agregarCargoLayout = new javax.swing.GroupLayout(agregarCargo.getContentPane());
        agregarCargo.getContentPane().setLayout(agregarCargoLayout);
        agregarCargoLayout.setHorizontalGroup(
            agregarCargoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(agregarCargoLayout.createSequentialGroup()
                .addGroup(agregarCargoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(agregarCargoLayout.createSequentialGroup()
                        .addGap(57, 57, 57)
                        .addComponent(jLabel56))
                    .addGroup(agregarCargoLayout.createSequentialGroup()
                        .addGap(66, 66, 66)
                        .addGroup(agregarCargoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(agregarCargoLayout.createSequentialGroup()
                                .addGap(105, 105, 105)
                                .addComponent(txtACargo, javax.swing.GroupLayout.PREFERRED_SIZE, 134, javax.swing.GroupLayout.PREFERRED_SIZE))
                            .addComponent(jLabel51)))
                    .addGroup(agregarCargoLayout.createSequentialGroup()
                        .addGap(96, 96, 96)
                        .addComponent(cmdIngresarCargo)
                        .addGap(28, 28, 28)
                        .addComponent(jButton31)))
                .addContainerGap(80, Short.MAX_VALUE))
        );
        agregarCargoLayout.setVerticalGroup(
            agregarCargoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(agregarCargoLayout.createSequentialGroup()
                .addGap(48, 48, 48)
                .addComponent(jLabel51)
                .addGap(18, 18, 18)
                .addGroup(agregarCargoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel56)
                    .addComponent(txtACargo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(36, 36, 36)
                .addGroup(agregarCargoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cmdIngresarCargo)
                    .addComponent(jButton31))
                .addContainerGap(57, Short.MAX_VALUE))
        );

        jLabel52.setFont(new java.awt.Font("Tahoma", 1, 11));
        jLabel52.setText("Cambiar de colegio:");

        jLabel57.setText("Escoja el colegio:");

        cbxColegio.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        cmdAgregarColegio.setText("Agregar Colegio");
        cmdAgregarColegio.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdAgregarColegioActionPerformed(evt);
            }
        });

        jButton4.setText("Cambiar");
        jButton4.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton4ActionPerformed(evt);
            }
        });

        jLabel60.setText("Promedio:");

        cbxPromedioC.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jButton30.setText("Cancelar");
        jButton30.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton30ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout cambiarInstitucionLayout = new javax.swing.GroupLayout(cambiarInstitucion.getContentPane());
        cambiarInstitucion.getContentPane().setLayout(cambiarInstitucionLayout);
        cambiarInstitucionLayout.setHorizontalGroup(
            cambiarInstitucionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(cambiarInstitucionLayout.createSequentialGroup()
                .addGroup(cambiarInstitucionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(cambiarInstitucionLayout.createSequentialGroup()
                        .addGap(97, 97, 97)
                        .addComponent(jLabel52))
                    .addGroup(cambiarInstitucionLayout.createSequentialGroup()
                        .addGap(24, 24, 24)
                        .addGroup(cambiarInstitucionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                            .addComponent(cmdAgregarColegio)
                            .addGroup(cambiarInstitucionLayout.createSequentialGroup()
                                .addGroup(cambiarInstitucionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(jLabel57)
                                    .addComponent(jLabel60))
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                .addGroup(cambiarInstitucionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(cbxPromedioC, javax.swing.GroupLayout.PREFERRED_SIZE, 195, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addComponent(cbxColegio, javax.swing.GroupLayout.PREFERRED_SIZE, 195, javax.swing.GroupLayout.PREFERRED_SIZE)))))
                    .addGroup(cambiarInstitucionLayout.createSequentialGroup()
                        .addGap(84, 84, 84)
                        .addComponent(jButton4)
                        .addGap(27, 27, 27)
                        .addComponent(jButton30)))
                .addContainerGap(80, Short.MAX_VALUE))
        );
        cambiarInstitucionLayout.setVerticalGroup(
            cambiarInstitucionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(cambiarInstitucionLayout.createSequentialGroup()
                .addGap(40, 40, 40)
                .addComponent(jLabel52)
                .addGap(26, 26, 26)
                .addGroup(cambiarInstitucionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cbxColegio, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel57))
                .addGap(18, 18, 18)
                .addComponent(cmdAgregarColegio)
                .addGap(32, 32, 32)
                .addGroup(cambiarInstitucionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(jLabel60)
                    .addComponent(cbxPromedioC, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(cambiarInstitucionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton4)
                    .addComponent(jButton30))
                .addContainerGap(50, Short.MAX_VALUE))
        );

        jLabel53.setFont(new java.awt.Font("Tahoma", 1, 11));
        jLabel53.setText("Ingrese el nombre del nuevo colegio:");

        jLabel58.setText("Agregar Colegio:");

        jButton3.setText("Agregar");
        jButton3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton3ActionPerformed(evt);
            }
        });

        jButton29.setText("Cancelar");
        jButton29.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton29ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout agregarColegioLayout = new javax.swing.GroupLayout(agregarColegio.getContentPane());
        agregarColegio.getContentPane().setLayout(agregarColegioLayout);
        agregarColegioLayout.setHorizontalGroup(
            agregarColegioLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(agregarColegioLayout.createSequentialGroup()
                .addGroup(agregarColegioLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(agregarColegioLayout.createSequentialGroup()
                        .addGap(57, 57, 57)
                        .addComponent(jLabel58))
                    .addGroup(agregarColegioLayout.createSequentialGroup()
                        .addGap(66, 66, 66)
                        .addComponent(jLabel53))
                    .addGroup(agregarColegioLayout.createSequentialGroup()
                        .addGap(146, 146, 146)
                        .addComponent(txtAColegio, javax.swing.GroupLayout.PREFERRED_SIZE, 159, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(agregarColegioLayout.createSequentialGroup()
                        .addGap(90, 90, 90)
                        .addComponent(jButton3)
                        .addGap(26, 26, 26)
                        .addComponent(jButton29)))
                .addContainerGap(80, Short.MAX_VALUE))
        );
        agregarColegioLayout.setVerticalGroup(
            agregarColegioLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(agregarColegioLayout.createSequentialGroup()
                .addGap(48, 48, 48)
                .addComponent(jLabel53)
                .addGap(18, 18, 18)
                .addGroup(agregarColegioLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel58)
                    .addComponent(txtAColegio, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(36, 36, 36)
                .addGroup(agregarColegioLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton3)
                    .addComponent(jButton29))
                .addContainerGap(57, Short.MAX_VALUE))
        );

        jLabel20.setFont(new java.awt.Font("Tahoma", 1, 11));
        jLabel20.setText("Género");

        jLabel21.setText("Escoja un género:");

        cbxGenero.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jButton10.setText("Cambiar");
        jButton10.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton10ActionPerformed(evt);
            }
        });

        jButton27.setText("Cancelar");
        jButton27.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton27ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout cambiarGeneroLayout = new javax.swing.GroupLayout(cambiarGenero.getContentPane());
        cambiarGenero.getContentPane().setLayout(cambiarGeneroLayout);
        cambiarGeneroLayout.setHorizontalGroup(
            cambiarGeneroLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(cambiarGeneroLayout.createSequentialGroup()
                .addGroup(cambiarGeneroLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(cambiarGeneroLayout.createSequentialGroup()
                        .addGap(56, 56, 56)
                        .addComponent(jLabel21)
                        .addGap(18, 18, 18)
                        .addComponent(cbxGenero, javax.swing.GroupLayout.PREFERRED_SIZE, 139, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(cambiarGeneroLayout.createSequentialGroup()
                        .addGap(147, 147, 147)
                        .addComponent(jLabel20))
                    .addGroup(cambiarGeneroLayout.createSequentialGroup()
                        .addGap(93, 93, 93)
                        .addComponent(jButton10)
                        .addGap(27, 27, 27)
                        .addComponent(jButton27)))
                .addContainerGap(100, Short.MAX_VALUE))
        );
        cambiarGeneroLayout.setVerticalGroup(
            cambiarGeneroLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(cambiarGeneroLayout.createSequentialGroup()
                .addGap(46, 46, 46)
                .addComponent(jLabel20)
                .addGap(33, 33, 33)
                .addGroup(cambiarGeneroLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel21)
                    .addComponent(cbxGenero, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(54, 54, 54)
                .addGroup(cambiarGeneroLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton10)
                    .addComponent(jButton27))
                .addContainerGap(110, Short.MAX_VALUE))
        );

        jLabel22.setFont(new java.awt.Font("Tahoma", 1, 11));
        jLabel22.setText("NACIONALIDAD");

        jLabel23.setText("Escoja una opción:");

        cbxNacionalidad.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jButton11.setText("Agregar Nacionalidad");
        jButton11.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton11ActionPerformed(evt);
            }
        });

        jButton12.setText("Cambiar");
        jButton12.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton12ActionPerformed(evt);
            }
        });

        jButton26.setText("Cancelar");
        jButton26.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton26ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout cambiarNacionalidadLayout = new javax.swing.GroupLayout(cambiarNacionalidad.getContentPane());
        cambiarNacionalidad.getContentPane().setLayout(cambiarNacionalidadLayout);
        cambiarNacionalidadLayout.setHorizontalGroup(
            cambiarNacionalidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(cambiarNacionalidadLayout.createSequentialGroup()
                .addGap(39, 39, 39)
                .addGroup(cambiarNacionalidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                    .addGroup(cambiarNacionalidadLayout.createSequentialGroup()
                        .addComponent(jLabel23)
                        .addGap(18, 18, 18)
                        .addGroup(cambiarNacionalidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(cbxNacionalidad, javax.swing.GroupLayout.PREFERRED_SIZE, 160, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jLabel22)))
                    .addGroup(cambiarNacionalidadLayout.createSequentialGroup()
                        .addGroup(cambiarNacionalidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                            .addComponent(jButton12)
                            .addComponent(txtANacionalidad))
                        .addGap(18, 18, 18)
                        .addGroup(cambiarNacionalidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jButton26)
                            .addComponent(jButton11))))
                .addContainerGap(93, Short.MAX_VALUE))
        );
        cambiarNacionalidadLayout.setVerticalGroup(
            cambiarNacionalidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(cambiarNacionalidadLayout.createSequentialGroup()
                .addGap(32, 32, 32)
                .addComponent(jLabel22)
                .addGap(36, 36, 36)
                .addGroup(cambiarNacionalidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel23)
                    .addComponent(cbxNacionalidad, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(cambiarNacionalidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(jButton11)
                    .addComponent(txtANacionalidad, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(41, 41, 41)
                .addGroup(cambiarNacionalidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton12)
                    .addComponent(jButton26))
                .addContainerGap(93, Short.MAX_VALUE))
        );

        jLabel24.setFont(new java.awt.Font("Tahoma", 1, 11));
        jLabel24.setText("RAZA O ETNIA");

        jLabel26.setText("Escoja una opcion:");

        cbxEtnia.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jButton13.setText("Agregar Raza o Etnia");
        jButton13.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton13ActionPerformed(evt);
            }
        });

        jButton14.setText("Cambiar");
        jButton14.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton14ActionPerformed(evt);
            }
        });

        jButton25.setText("Cancelar");
        jButton25.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton25ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout cambiarEtniaLayout = new javax.swing.GroupLayout(cambiarEtnia.getContentPane());
        cambiarEtnia.getContentPane().setLayout(cambiarEtniaLayout);
        cambiarEtniaLayout.setHorizontalGroup(
            cambiarEtniaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(cambiarEtniaLayout.createSequentialGroup()
                .addGroup(cambiarEtniaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(cambiarEtniaLayout.createSequentialGroup()
                        .addGap(55, 55, 55)
                        .addGroup(cambiarEtniaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                            .addGroup(cambiarEtniaLayout.createSequentialGroup()
                                .addComponent(jLabel26)
                                .addGap(18, 18, 18)
                                .addComponent(cbxEtnia, javax.swing.GroupLayout.PREFERRED_SIZE, 146, javax.swing.GroupLayout.PREFERRED_SIZE))
                            .addGroup(cambiarEtniaLayout.createSequentialGroup()
                                .addGroup(cambiarEtniaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                    .addComponent(jButton14)
                                    .addComponent(txtAEtnia))
                                .addGroup(cambiarEtniaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addGroup(cambiarEtniaLayout.createSequentialGroup()
                                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                        .addComponent(jButton13))
                                    .addGroup(cambiarEtniaLayout.createSequentialGroup()
                                        .addGap(24, 24, 24)
                                        .addComponent(jButton25))))))
                    .addGroup(cambiarEtniaLayout.createSequentialGroup()
                        .addGap(143, 143, 143)
                        .addComponent(jLabel24)))
                .addContainerGap(91, Short.MAX_VALUE))
        );
        cambiarEtniaLayout.setVerticalGroup(
            cambiarEtniaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(cambiarEtniaLayout.createSequentialGroup()
                .addGap(41, 41, 41)
                .addComponent(jLabel24)
                .addGap(30, 30, 30)
                .addGroup(cambiarEtniaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel26)
                    .addComponent(cbxEtnia, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(cambiarEtniaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton13)
                    .addComponent(txtAEtnia, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(43, 43, 43)
                .addGroup(cambiarEtniaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton14)
                    .addComponent(jButton25))
                .addContainerGap(88, Short.MAX_VALUE))
        );

        jLabel63.setFont(new java.awt.Font("Tahoma", 1, 11));
        jLabel63.setText("CIUDAD");

        jLabel64.setText("Eliga una ciudad:");

        cmbCiudad.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jButton22.setText("Agregar Ciudad");
        jButton22.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton22ActionPerformed(evt);
            }
        });

        jButton23.setText("Cambiar");
        jButton23.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton23ActionPerformed(evt);
            }
        });

        jButton24.setText("Cancelar");
        jButton24.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton24ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout cambiarCiudadLayout = new javax.swing.GroupLayout(cambiarCiudad.getContentPane());
        cambiarCiudad.getContentPane().setLayout(cambiarCiudadLayout);
        cambiarCiudadLayout.setHorizontalGroup(
            cambiarCiudadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(cambiarCiudadLayout.createSequentialGroup()
                .addGroup(cambiarCiudadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(cambiarCiudadLayout.createSequentialGroup()
                        .addGap(167, 167, 167)
                        .addComponent(jLabel63))
                    .addGroup(cambiarCiudadLayout.createSequentialGroup()
                        .addGap(51, 51, 51)
                        .addComponent(jLabel64)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(cambiarCiudadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                            .addComponent(txtACiudad)
                            .addComponent(cmbCiudad, 0, 179, Short.MAX_VALUE)
                            .addComponent(jButton22, javax.swing.GroupLayout.Alignment.TRAILING)))
                    .addGroup(cambiarCiudadLayout.createSequentialGroup()
                        .addGap(97, 97, 97)
                        .addComponent(jButton23)
                        .addGap(28, 28, 28)
                        .addComponent(jButton24)))
                .addContainerGap(85, Short.MAX_VALUE))
        );
        cambiarCiudadLayout.setVerticalGroup(
            cambiarCiudadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(cambiarCiudadLayout.createSequentialGroup()
                .addGap(57, 57, 57)
                .addComponent(jLabel63)
                .addGap(18, 18, 18)
                .addGroup(cambiarCiudadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel64)
                    .addComponent(cmbCiudad, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addComponent(txtACiudad, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addComponent(jButton22)
                .addGap(30, 30, 30)
                .addGroup(cambiarCiudadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton23)
                    .addComponent(jButton24))
                .addContainerGap(66, Short.MAX_VALUE))
        );

        jLabel54.setText("Facultad:");

        jLabel59.setText("Escuela:");

        jLabel65.setText("Titulo:");

        jLabel66.setText("Año Graduación:");

        txtAnioGraduacion.setText("jTextField5");

        jLabel67.setText("Promedio:");

        bEditar.setText("Editar");
        bEditar.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bEditarActionPerformed(evt);
            }
        });

        jButton28.setText("Cancelar");
        jButton28.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton28ActionPerformed(evt);
            }
        });

        cbxFacultad.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
        cbxFacultad.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cbxFacultadActionPerformed(evt);
            }
        });

        cbxEscuela.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
        cbxEscuela.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                cbxEscuelaMouseClicked(evt);
            }
        });
        cbxEscuela.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cbxEscuelaActionPerformed(evt);
            }
        });

        cbxPromedioU.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        cbxTitulo.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        bGuardar.setText("Guardar");
        bGuardar.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bGuardarActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout editarUniversidadLayout = new javax.swing.GroupLayout(editarUniversidad.getContentPane());
        editarUniversidad.getContentPane().setLayout(editarUniversidadLayout);
        editarUniversidadLayout.setHorizontalGroup(
            editarUniversidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(editarUniversidadLayout.createSequentialGroup()
                .addGap(45, 45, 45)
                .addGroup(editarUniversidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel66)
                    .addComponent(jLabel54)
                    .addComponent(jLabel65)
                    .addComponent(jLabel59)
                    .addComponent(jLabel67))
                .addGap(18, 18, 18)
                .addGroup(editarUniversidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(cbxTitulo, 0, 209, Short.MAX_VALUE)
                    .addComponent(cbxPromedioU, 0, 209, Short.MAX_VALUE)
                    .addComponent(cbxEscuela, 0, 209, Short.MAX_VALUE)
                    .addComponent(cbxFacultad, 0, 209, Short.MAX_VALUE)
                    .addComponent(txtAnioGraduacion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addContainerGap(48, javax.swing.GroupLayout.PREFERRED_SIZE))
            .addGroup(editarUniversidadLayout.createSequentialGroup()
                .addGap(90, 90, 90)
                .addGroup(editarUniversidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(bGuardar)
                    .addGroup(editarUniversidadLayout.createSequentialGroup()
                        .addComponent(bEditar)
                        .addGap(35, 35, 35)
                        .addComponent(jButton28)))
                .addContainerGap(139, Short.MAX_VALUE))
        );
        editarUniversidadLayout.setVerticalGroup(
            editarUniversidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(editarUniversidadLayout.createSequentialGroup()
                .addGap(28, 28, 28)
                .addGroup(editarUniversidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(jLabel54)
                    .addComponent(cbxFacultad, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(editarUniversidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel59)
                    .addComponent(cbxEscuela, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(editarUniversidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel65)
                    .addComponent(cbxTitulo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(editarUniversidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel66)
                    .addComponent(txtAnioGraduacion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(editarUniversidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel67)
                    .addComponent(cbxPromedioU, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(27, 27, 27)
                .addGroup(editarUniversidadLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(bEditar)
                    .addComponent(jButton28))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(bGuardar)
                .addContainerGap(69, Short.MAX_VALUE))
        );

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        jLabel1.setText("Nombres:");

        jLabel2.setText("Cédula:");

        jLabel3.setText("Apellidos:");

        jLabel5.setText("Teléfono:");

        jLabel6.setText("Dirección:");

        txtDireccion.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                txtDireccionActionPerformed(evt);
            }
        });

        cmdLlamarEncuesta.setText("Modificar");
        cmdLlamarEncuesta.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdLlamarEncuestaActionPerformed(evt);
            }
        });

        jLabel4.setText("Genero:");

        jLabel8.setText("Nacionalidad:");

        jLabel9.setText("Raza o Etnia:");

        txtCedula.setEditable(false);

        tablaTelefonos.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "Numero"
            }
        ));
        jScrollPane3.setViewportView(tablaTelefonos);

        txtGenero.setEditable(false);

        txtNacionalidad.setEditable(false);

        txtRaza.setEditable(false);

        jLabel7.setText("Correo Electronico:");

        tablaCorreos.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "Correo Electronico"
            }
        ));
        jScrollPane5.setViewportView(tablaCorreos);

        cmdAgregarT.setText("Agregar");
        cmdAgregarT.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdAgregarTActionPerformed(evt);
            }
        });

        cmdeliminarT.setText("Eliminar Telefono ");
        cmdeliminarT.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdeliminarTActionPerformed(evt);
            }
        });

        cmdAgregarC.setText("Agregar");
        cmdAgregarC.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdAgregarCActionPerformed(evt);
            }
        });

        cmdeliminarC.setText("Eliminar Correo");
        cmdeliminarC.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdeliminarCActionPerformed(evt);
            }
        });

        cmdBuscar.setText("Buscar");
        cmdBuscar.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdBuscarActionPerformed(evt);
            }
        });

        jButton7.setText("Cambiar");
        jButton7.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton7ActionPerformed(evt);
            }
        });

        jButton8.setText("Cambiar");
        jButton8.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton8ActionPerformed(evt);
            }
        });

        jButton9.setText("Cambiar");
        jButton9.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton9ActionPerformed(evt);
            }
        });

        jButton17.setText("Elegir como Principal");
        jButton17.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton17ActionPerformed(evt);
            }
        });

        jLabel27.setText("Teléfono Principal:");

        txtTPrincipal.setEditable(false);

        jLabel28.setText("Correo Principal:");

        txtCPrincipal.setEditable(false);

        jButton18.setText("Elegir como Principal");
        jButton18.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton18ActionPerformed(evt);
            }
        });

        jButton19.setText("Cancelar");
        jButton19.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton19ActionPerformed(evt);
            }
        });

        jLabel61.setText("Contraseña:");

        jLabel62.setText("Ciudad:");

        txtCiudad.setEditable(false);

        jButton16.setText("Cambiar");
        jButton16.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton16ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(88, 88, 88)
                        .addComponent(jLabel3)
                        .addGap(64, 64, 64)
                        .addComponent(txtApellidos, javax.swing.GroupLayout.PREFERRED_SIZE, 372, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(88, 88, 88)
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jLabel2)
                            .addComponent(jLabel1)
                            .addComponent(jLabel61))
                        .addGap(41, 41, 41)
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(jPanel1Layout.createSequentialGroup()
                                .addGap(8, 8, 8)
                                .addComponent(txtCedula, javax.swing.GroupLayout.PREFERRED_SIZE, 372, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                .addComponent(cmdBuscar))
                            .addGroup(jPanel1Layout.createSequentialGroup()
                                .addGap(9, 9, 9)
                                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                                    .addComponent(txtContraseña, javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(txtNombres, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 372, Short.MAX_VALUE)))))
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(40, 40, 40)
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                            .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addGroup(jPanel1Layout.createSequentialGroup()
                                    .addGap(48, 48, 48)
                                    .addComponent(jLabel5)
                                    .addGap(64, 64, 64)
                                    .addComponent(txttelefono, javax.swing.GroupLayout.PREFERRED_SIZE, 155, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addGap(146, 146, 146)
                                    .addComponent(cmdAgregarT))
                                .addGroup(jPanel1Layout.createSequentialGroup()
                                    .addGap(30, 30, 30)
                                    .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                        .addComponent(jButton17)
                                        .addGroup(jPanel1Layout.createSequentialGroup()
                                            .addGap(17, 17, 17)
                                            .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                                .addComponent(jLabel27)
                                                .addComponent(txtTPrincipal, javax.swing.GroupLayout.PREFERRED_SIZE, 106, javax.swing.GroupLayout.PREFERRED_SIZE))))
                                    .addGap(5, 5, 5)
                                    .addComponent(jScrollPane3, javax.swing.GroupLayout.PREFERRED_SIZE, 239, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addGap(10, 10, 10)
                                    .addComponent(cmdeliminarT))
                                .addGroup(jPanel1Layout.createSequentialGroup()
                                    .addGap(160, 160, 160)
                                    .addComponent(txtcorreo, javax.swing.GroupLayout.PREFERRED_SIZE, 223, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addGap(77, 77, 77)
                                    .addComponent(cmdAgregarC))
                                .addGroup(jPanel1Layout.createSequentialGroup()
                                    .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                        .addGroup(jPanel1Layout.createSequentialGroup()
                                            .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                                .addComponent(jLabel28)
                                                .addComponent(txtCPrincipal, javax.swing.GroupLayout.PREFERRED_SIZE, 150, javax.swing.GroupLayout.PREFERRED_SIZE)
                                                .addComponent(jLabel7))
                                            .addGap(14, 14, 14))
                                        .addGroup(jPanel1Layout.createSequentialGroup()
                                            .addComponent(jButton18)
                                            .addGap(18, 18, 18)))
                                    .addComponent(jScrollPane5, javax.swing.GroupLayout.PREFERRED_SIZE, 239, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addGap(22, 22, 22)
                                    .addComponent(cmdeliminarC))
                                .addGroup(jPanel1Layout.createSequentialGroup()
                                    .addGap(55, 55, 55)
                                    .addComponent(jLabel4)
                                    .addGap(64, 64, 64)
                                    .addComponent(txtGenero, javax.swing.GroupLayout.PREFERRED_SIZE, 263, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addGap(7, 7, 7)
                                    .addComponent(jButton7))
                                .addGroup(jPanel1Layout.createSequentialGroup()
                                    .addGap(30, 30, 30)
                                    .addComponent(jLabel8)
                                    .addGap(64, 64, 64)
                                    .addComponent(txtNacionalidad, javax.swing.GroupLayout.PREFERRED_SIZE, 260, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addGap(10, 10, 10)
                                    .addComponent(jButton8))
                                .addGroup(jPanel1Layout.createSequentialGroup()
                                    .addGap(30, 30, 30)
                                    .addComponent(jLabel9)
                                    .addGap(64, 64, 64)
                                    .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                        .addGroup(jPanel1Layout.createSequentialGroup()
                                            .addComponent(cmdLlamarEncuesta)
                                            .addGap(46, 46, 46)
                                            .addComponent(jButton19))
                                        .addGroup(jPanel1Layout.createSequentialGroup()
                                            .addComponent(txtRaza, javax.swing.GroupLayout.PREFERRED_SIZE, 260, javax.swing.GroupLayout.PREFERRED_SIZE)
                                            .addGap(10, 10, 10)
                                            .addComponent(jButton9)))))
                            .addGroup(jPanel1Layout.createSequentialGroup()
                                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(jLabel6)
                                    .addComponent(jLabel62))
                                .addGap(64, 64, 64)
                                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                    .addGroup(jPanel1Layout.createSequentialGroup()
                                        .addComponent(txtCiudad, javax.swing.GroupLayout.PREFERRED_SIZE, 296, javax.swing.GroupLayout.PREFERRED_SIZE)
                                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                        .addComponent(jButton16))
                                    .addComponent(txtDireccion, javax.swing.GroupLayout.PREFERRED_SIZE, 372, javax.swing.GroupLayout.PREFERRED_SIZE))))))
                .addGap(21, 21, 21))
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(4, 4, 4)
                        .addComponent(jLabel2))
                    .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(cmdBuscar)
                        .addComponent(txtCedula, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel61)
                    .addComponent(txtContraseña, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(17, 17, 17)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel1)
                    .addComponent(txtNombres, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(11, 11, 11)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(3, 3, 3)
                        .addComponent(jLabel3))
                    .addComponent(txtApellidos, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(3, 3, 3)
                        .addComponent(jLabel6))
                    .addComponent(txtDireccion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel62)
                    .addComponent(txtCiudad, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jButton16))
                .addGap(21, 21, 21)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel5)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(1, 1, 1)
                        .addComponent(txttelefono, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addComponent(cmdAgregarT))
                .addGap(11, 11, 11)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(5, 5, 5)
                        .addComponent(jLabel27)
                        .addGap(11, 11, 11)
                        .addComponent(txtTPrincipal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(8, 8, 8)
                        .addComponent(jButton17))
                    .addComponent(jScrollPane3, javax.swing.GroupLayout.PREFERRED_SIZE, 82, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(30, 30, 30)
                        .addComponent(cmdeliminarT)))
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(16, 16, 16)
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(txtcorreo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(cmdAgregarC)))
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(18, 18, 18)
                        .addComponent(jLabel7)))
                .addGap(8, 8, 8)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(9, 9, 9)
                        .addComponent(jLabel28)
                        .addGap(6, 6, 6)
                        .addComponent(txtCPrincipal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(jButton18))
                    .addComponent(jScrollPane5, javax.swing.GroupLayout.PREFERRED_SIZE, 82, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(28, 28, 28)
                        .addComponent(cmdeliminarC)))
                .addGap(19, 19, 19)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jButton7)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(2, 2, 2)
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jLabel4)
                            .addComponent(txtGenero, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))
                .addGap(28, 28, 28)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(3, 3, 3)
                        .addComponent(jLabel8))
                    .addComponent(txtNacionalidad, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(1, 1, 1)
                        .addComponent(jButton8)))
                .addGap(20, 20, 20)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(3, 3, 3)
                        .addComponent(jLabel9))
                    .addComponent(txtRaza, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(jPanel1Layout.createSequentialGroup()
                        .addGap(4, 4, 4)
                        .addComponent(jButton9)))
                .addGap(18, 18, 18)
                .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cmdLlamarEncuesta)
                    .addComponent(jButton19))
                .addContainerGap())
        );

        jTabbedPane1.addTab("Datos Personales", jPanel1);

        jLabel38.setText("Trabajo Actual:");

        tablaTrabajoActual.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Empresa", "Cargo", "Descripción", "Fecha Inicio"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        tablaTrabajoActual.getTableHeader().setReorderingAllowed(false);
        jScrollPane2.setViewportView(tablaTrabajoActual);
        tablaTrabajoActual.getColumnModel().getColumn(2).setHeaderValue("Descripción");
        tablaTrabajoActual.getColumnModel().getColumn(3).setHeaderValue("Fecha Inicio");

        jLabel39.setText("Historial de Trabajo:");

        tablaHistorialTrabajo.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null}
            },
            new String [] {
                "Empresa", "Cargo", "Descripción", "Fecha Inicio", "Fecha Fin"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, true, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        tablaHistorialTrabajo.getTableHeader().setReorderingAllowed(false);
        jScrollPane4.setViewportView(tablaHistorialTrabajo);

        cmdFinalizar.setText("Finalizar Trabajo ");
        cmdFinalizar.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdFinalizarActionPerformed(evt);
            }
        });

        cmdAgregar.setText("Agregar Trabajo Actual ");
        cmdAgregar.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdAgregarActionPerformed(evt);
            }
        });

        jButton2.setText("Eliminar Trabajo");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
        jPanel4.setLayout(jPanel4Layout);
        jPanel4Layout.setHorizontalGroup(
            jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel4Layout.createSequentialGroup()
                .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel4Layout.createSequentialGroup()
                        .addGap(45, 45, 45)
                        .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 514, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(jPanel4Layout.createSequentialGroup()
                        .addGap(120, 120, 120)
                        .addComponent(cmdAgregar)
                        .addGap(108, 108, 108)
                        .addComponent(cmdFinalizar))
                    .addGroup(jPanel4Layout.createSequentialGroup()
                        .addGap(264, 264, 264)
                        .addComponent(jButton2)))
                .addContainerGap(123, Short.MAX_VALUE))
            .addGroup(jPanel4Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel4Layout.createSequentialGroup()
                        .addGap(0, 0, Short.MAX_VALUE)
                        .addComponent(jLabel38)
                        .addGap(731, 731, 731))
                    .addGroup(jPanel4Layout.createSequentialGroup()
                        .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(jPanel4Layout.createSequentialGroup()
                                .addComponent(jLabel39)
                                .addGap(452, 452, 452))
                            .addGroup(jPanel4Layout.createSequentialGroup()
                                .addGap(35, 35, 35)
                                .addComponent(jScrollPane4, javax.swing.GroupLayout.DEFAULT_SIZE, 538, Short.MAX_VALUE)))
                        .addGap(232, 232, 232))))
        );
        jPanel4Layout.setVerticalGroup(
            jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel4Layout.createSequentialGroup()
                .addGap(26, 26, 26)
                .addComponent(jLabel38)
                .addGap(18, 18, 18)
                .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 93, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(40, 40, 40)
                .addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cmdAgregar)
                    .addComponent(cmdFinalizar))
                .addGap(18, 18, 18)
                .addComponent(jButton2)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 70, Short.MAX_VALUE)
                .addComponent(jLabel39)
                .addGap(18, 18, 18)
                .addComponent(jScrollPane4, javax.swing.GroupLayout.PREFERRED_SIZE, 93, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(223, 223, 223))
        );

        jTabbedPane1.addTab("Información Laboral", jPanel4);

        jLabel13.setText("Tipo:");

        jLabel14.setText("Contacto:");

        txtContacto.setEditable(false);

        txtTipo.setEditable(false);
        txtTipo.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                txtTipoActionPerformed(evt);
            }
        });

        jButton15.setText("Cambiar");
        jButton15.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton15ActionPerformed(evt);
            }
        });

        cmdConfTipo.setText("Confirmar");
        cmdConfTipo.setEnabled(false);
        cmdConfTipo.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdConfTipoActionPerformed(evt);
            }
        });

        cbxTipoContacto.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jLabel29.setText("Teléfono Principal:");

        jLabel30.setText("Teléfono:");

        txttelefono1.setEditable(false);

        tablaTelefonos1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "Numero"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jScrollPane12.setViewportView(tablaTelefonos1);

        txtTPrincipal1.setEditable(false);

        jButton20.setText("Elegir como Principal");
        jButton20.setEnabled(false);
        jButton20.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton20ActionPerformed(evt);
            }
        });

        jLabel45.setText("Correo Electronico:");

        jLabel47.setText("Correo Principal:");

        txtCPrincipal1.setEditable(false);

        jButton21.setText("Elegir como Principal");
        jButton21.setEnabled(false);
        jButton21.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton21ActionPerformed(evt);
            }
        });

        tablaCorreos1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "Correo Electronico"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jScrollPane13.setViewportView(tablaCorreos1);

        txtcorreo1.setEditable(false);

        cmdeliminarC1.setText("Eliminar Correo");
        cmdeliminarC1.setEnabled(false);
        cmdeliminarC1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdeliminarC1ActionPerformed(evt);
            }
        });

        cmdAgregarC1.setText("Agregar");
        cmdAgregarC1.setEnabled(false);
        cmdAgregarC1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdAgregarC1ActionPerformed(evt);
            }
        });

        cmdeliminarT1.setText("Eliminar Telefono ");
        cmdeliminarT1.setEnabled(false);
        cmdeliminarT1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdeliminarT1ActionPerformed(evt);
            }
        });

        cmdAgregarT1.setText("Agregar");
        cmdAgregarT1.setEnabled(false);
        cmdAgregarT1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdAgregarT1ActionPerformed(evt);
            }
        });

        jLabel49.setText("Otro:");

        txtOtro.setEditable(false);

        javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
        jPanel2.setLayout(jPanel2Layout);
        jPanel2Layout.setHorizontalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addGap(92, 92, 92)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(jLabel14)
                    .addComponent(jLabel13))
                .addGap(50, 50, 50)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(txtContacto, javax.swing.GroupLayout.DEFAULT_SIZE, 219, Short.MAX_VALUE)
                    .addComponent(txtTipo, javax.swing.GroupLayout.DEFAULT_SIZE, 219, Short.MAX_VALUE))
                .addGap(273, 273, 273))
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addGap(146, 146, 146)
                .addComponent(jLabel49)
                .addGap(71, 71, 71)
                .addComponent(txtOtro, javax.swing.GroupLayout.PREFERRED_SIZE, 270, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(169, Short.MAX_VALUE))
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
                .addContainerGap(158, Short.MAX_VALUE)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
                        .addComponent(cbxTipoContacto, javax.swing.GroupLayout.PREFERRED_SIZE, 154, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(26, 26, 26)
                        .addComponent(jButton15, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(220, 220, 220))
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
                        .addComponent(cmdConfTipo)
                        .addGap(297, 297, 297))))
            .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel2Layout.createSequentialGroup()
                    .addGap(75, 75, 75)
                    .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(jPanel2Layout.createSequentialGroup()
                            .addGap(48, 48, 48)
                            .addComponent(jLabel30)
                            .addGap(64, 64, 64)
                            .addComponent(txttelefono1, javax.swing.GroupLayout.PREFERRED_SIZE, 155, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGap(146, 146, 146)
                            .addComponent(cmdAgregarT1))
                        .addGroup(jPanel2Layout.createSequentialGroup()
                            .addGap(30, 30, 30)
                            .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addComponent(jButton20)
                                .addGroup(jPanel2Layout.createSequentialGroup()
                                    .addGap(17, 17, 17)
                                    .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                        .addComponent(jLabel29)
                                        .addComponent(txtTPrincipal1, javax.swing.GroupLayout.PREFERRED_SIZE, 106, javax.swing.GroupLayout.PREFERRED_SIZE))))
                            .addGap(5, 5, 5)
                            .addComponent(jScrollPane12, javax.swing.GroupLayout.PREFERRED_SIZE, 239, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGap(10, 10, 10)
                            .addComponent(cmdeliminarT1))
                        .addGroup(jPanel2Layout.createSequentialGroup()
                            .addGap(160, 160, 160)
                            .addComponent(txtcorreo1, javax.swing.GroupLayout.PREFERRED_SIZE, 223, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGap(77, 77, 77)
                            .addComponent(cmdAgregarC1))
                        .addGroup(jPanel2Layout.createSequentialGroup()
                            .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                .addGroup(jPanel2Layout.createSequentialGroup()
                                    .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                        .addComponent(jLabel47)
                                        .addComponent(txtCPrincipal1, javax.swing.GroupLayout.PREFERRED_SIZE, 150, javax.swing.GroupLayout.PREFERRED_SIZE)
                                        .addComponent(jLabel45))
                                    .addGap(14, 14, 14))
                                .addGroup(jPanel2Layout.createSequentialGroup()
                                    .addComponent(jButton21)
                                    .addGap(18, 18, 18)))
                            .addComponent(jScrollPane13, javax.swing.GroupLayout.PREFERRED_SIZE, 239, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGap(22, 22, 22)
                            .addComponent(cmdeliminarC1)))
                    .addContainerGap(76, Short.MAX_VALUE)))
        );
        jPanel2Layout.setVerticalGroup(
            jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel2Layout.createSequentialGroup()
                .addGap(64, 64, 64)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel13)
                    .addComponent(txtTipo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jLabel14)
                    .addComponent(txtContacto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(18, 18, 18)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(jButton15)
                    .addComponent(cbxTipoContacto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 337, Short.MAX_VALUE)
                .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel49)
                    .addComponent(txtOtro, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addGap(52, 52, 52)
                .addComponent(cmdConfTipo)
                .addGap(78, 78, 78))
            .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel2Layout.createSequentialGroup()
                    .addGap(214, 214, 214)
                    .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addComponent(jLabel30)
                        .addGroup(jPanel2Layout.createSequentialGroup()
                            .addGap(1, 1, 1)
                            .addComponent(txttelefono1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addComponent(cmdAgregarT1))
                    .addGap(11, 11, 11)
                    .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(jPanel2Layout.createSequentialGroup()
                            .addGap(5, 5, 5)
                            .addComponent(jLabel29)
                            .addGap(11, 11, 11)
                            .addComponent(txtTPrincipal1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGap(8, 8, 8)
                            .addComponent(jButton20))
                        .addComponent(jScrollPane12, javax.swing.GroupLayout.PREFERRED_SIZE, 82, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGroup(jPanel2Layout.createSequentialGroup()
                            .addGap(30, 30, 30)
                            .addComponent(cmdeliminarT1)))
                    .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(jPanel2Layout.createSequentialGroup()
                            .addGap(16, 16, 16)
                            .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addComponent(txtcorreo1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addComponent(cmdAgregarC1)))
                        .addGroup(jPanel2Layout.createSequentialGroup()
                            .addGap(18, 18, 18)
                            .addComponent(jLabel45)))
                    .addGap(8, 8, 8)
                    .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                        .addGroup(jPanel2Layout.createSequentialGroup()
                            .addGap(9, 9, 9)
                            .addComponent(jLabel47)
                            .addGap(6, 6, 6)
                            .addComponent(txtCPrincipal1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(jButton21))
                        .addComponent(jScrollPane13, javax.swing.GroupLayout.PREFERRED_SIZE, 82, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGroup(jPanel2Layout.createSequentialGroup()
                            .addGap(28, 28, 28)
                            .addComponent(cmdeliminarC1)))
                    .addContainerGap(214, Short.MAX_VALUE)))
        );

        jTabbedPane1.addTab("Información de Contacto", jPanel2);

        jLabel15.setText("Estudios Secundarios:");

        jLabel16.setText("Nombre de la Institución:");

        jLabel17.setText("Promedio:");

        jLabel18.setText("Estudios de Tercer Nivel:");

        jLabel19.setText("Títulos de la Universidad de Cuenca:");

        jLabel25.setText("Títulos de otras Universidades:");

        jLabel31.setText("Estudios Avanzados:");

        jLabel35.setText("Estudios del representante y/o de los padres:");

        tablaTitulosUCuenca.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null}
            },
            new String [] {
                "Facultad", "Escuela", "Título", "Año de Graduación", "Promedio"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        tablaTitulosUCuenca.getTableHeader().setReorderingAllowed(false);
        jScrollPane6.setViewportView(tablaTitulosUCuenca);
        tablaTitulosUCuenca.getColumnModel().getColumn(1).setResizable(false);

        tablaRepresentante.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null},
                {null, null},
                {null, null},
                {null, null}
            },
            new String [] {
                "Representante/Padre", "Nivel Educacion"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        tablaRepresentante.getTableHeader().setReorderingAllowed(false);
        jScrollPane7.setViewportView(tablaRepresentante);

        jLabel10.setText("Representante:");

        jTextField3.setText("jTextField3");

        cmdeditarSecundarios.setText("Editar");
        cmdeditarSecundarios.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdeditarSecundariosActionPerformed(evt);
            }
        });

        tablaEstudiosAvanzados1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null},
                {null, null},
                {null, null},
                {null, null}
            },
            new String [] {
                "Tipo Estudio", "Campo"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        tablaEstudiosAvanzados1.getTableHeader().setReorderingAllowed(false);
        jScrollPane10.setViewportView(tablaEstudiosAvanzados1);
        tablaEstudiosAvanzados1.getColumnModel().getColumn(1).setResizable(false);

        tablaTitulosUniversidades.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null}
            },
            new String [] {
                "Facultad", "Escuela", "Título", "Año de Graduación", "Promedio"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, true, true, true
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        tablaTitulosUniversidades.getTableHeader().setReorderingAllowed(false);
        jScrollPane11.setViewportView(tablaTitulosUniversidades);
        tablaTitulosUniversidades.getColumnModel().getColumn(1).setResizable(false);

        jButton35.setText("Guardar Cambios");
        jButton35.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton35ActionPerformed(evt);
            }
        });

        jButton36.setText("Cancelar");

        jButton5.setText("Editar");
        jButton5.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton5ActionPerformed(evt);
            }
        });

        cbxRepresentante.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));

        jButton6.setText("Nuevo");
        jButton6.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton6ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
        jPanel3.setLayout(jPanel3Layout);
        jPanel3Layout.setHorizontalGroup(
            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel3Layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
                        .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jLabel16)
                            .addComponent(txtInstitucion, javax.swing.GroupLayout.PREFERRED_SIZE, 250, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(jPanel3Layout.createSequentialGroup()
                                .addComponent(txtPromedioI, javax.swing.GroupLayout.PREFERRED_SIZE, 198, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(18, 18, 18)
                                .addComponent(cmdeditarSecundarios, javax.swing.GroupLayout.PREFERRED_SIZE, 102, javax.swing.GroupLayout.PREFERRED_SIZE))
                            .addComponent(jLabel17))
                        .addGap(231, 231, 231))
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
                        .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jSeparator1, javax.swing.GroupLayout.DEFAULT_SIZE, 547, Short.MAX_VALUE)
                            .addComponent(jScrollPane6, javax.swing.GroupLayout.DEFAULT_SIZE, 547, Short.MAX_VALUE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                        .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jButton5, javax.swing.GroupLayout.PREFERRED_SIZE, 69, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jButton6))
                        .addGap(179, 179, 179))
                    .addGroup(jPanel3Layout.createSequentialGroup()
                        .addComponent(jScrollPane11, javax.swing.GroupLayout.DEFAULT_SIZE, 593, Short.MAX_VALUE)
                        .addGap(212, 212, 212))
                    .addGroup(jPanel3Layout.createSequentialGroup()
                        .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jLabel19)
                            .addComponent(jLabel18)
                            .addComponent(jLabel15)
                            .addComponent(jLabel25)
                            .addComponent(jLabel31))
                        .addContainerGap(498, Short.MAX_VALUE))
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
                        .addComponent(jSeparator2, javax.swing.GroupLayout.DEFAULT_SIZE, 593, Short.MAX_VALUE)
                        .addGap(212, 212, 212))))
            .addGroup(jPanel3Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane10, javax.swing.GroupLayout.PREFERRED_SIZE, 579, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(226, Short.MAX_VALUE))
            .addGroup(jPanel3Layout.createSequentialGroup()
                .addComponent(jSeparator3, javax.swing.GroupLayout.DEFAULT_SIZE, 593, Short.MAX_VALUE)
                .addGap(222, 222, 222))
            .addGroup(jPanel3Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jLabel35)
                .addContainerGap(586, Short.MAX_VALUE))
            .addGroup(jPanel3Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jLabel10)
                .addGap(35, 35, 35)
                .addComponent(cbxRepresentante, javax.swing.GroupLayout.PREFERRED_SIZE, 129, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(565, Short.MAX_VALUE))
            .addGroup(jPanel3Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane7, javax.swing.GroupLayout.DEFAULT_SIZE, 439, Short.MAX_VALUE)
                .addGap(92, 92, 92)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                    .addComponent(jButton35)
                    .addComponent(jButton36))
                .addGap(159, 159, 159))
        );
        jPanel3Layout.setVerticalGroup(
            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel3Layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jLabel15)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel16)
                    .addComponent(jLabel17))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(txtInstitucion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtPromedioI, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(cmdeditarSecundarios))
                .addGap(18, 18, 18)
                .addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jLabel18)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jLabel19)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel3Layout.createSequentialGroup()
                        .addComponent(jScrollPane6, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(18, 18, 18)
                        .addComponent(jLabel25))
                    .addGroup(jPanel3Layout.createSequentialGroup()
                        .addComponent(jButton5)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jButton6)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 26, Short.MAX_VALUE)
                .addComponent(jScrollPane11, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18)
                .addComponent(jSeparator2, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jLabel31)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jScrollPane10, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jSeparator3, javax.swing.GroupLayout.PREFERRED_SIZE, 12, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jLabel35)
                .addGap(6, 6, 6)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addGroup(jPanel3Layout.createSequentialGroup()
                        .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel10)
                            .addComponent(cbxRepresentante, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jScrollPane7, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addContainerGap())
                    .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
                        .addComponent(jButton35)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jButton36)
                        .addGap(16, 16, 16))))
        );

        jTabbedPane1.addTab("Información Academica", jPanel3);

        jLabel40.setText("Encuestas que ha llenado:");

        tablaEncuestas.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null},
                {null, null, null},
                {null, null, null}
            },
            new String [] {
                "Número Encuesta", "Descripción", "Estado"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        tablaEncuestas.getTableHeader().setReorderingAllowed(false);
        jScrollPane8.setViewportView(tablaEncuestas);

        jLabel41.setText("Encuestas que puede llenar:");

        tablaEncuestasLLenar.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null},
                {null, null, null},
                {null, null, null}
            },
            new String [] {
                "Número Encuesta", "Descripción", "Estado"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        tablaEncuestasLLenar.getTableHeader().setReorderingAllowed(false);
        jScrollPane9.setViewportView(tablaEncuestasLLenar);

        javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
        jPanel5.setLayout(jPanel5Layout);
        jPanel5Layout.setHorizontalGroup(
            jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel5Layout.createSequentialGroup()
                .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(jPanel5Layout.createSequentialGroup()
                        .addGap(138, 138, 138)
                        .addComponent(jLabel40))
                    .addGroup(jPanel5Layout.createSequentialGroup()
                        .addGap(24, 24, 24)
                        .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jScrollPane9, javax.swing.GroupLayout.PREFERRED_SIZE, 632, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGroup(jPanel5Layout.createSequentialGroup()
                                .addGap(114, 114, 114)
                                .addComponent(jLabel41))
                            .addComponent(jScrollPane8, javax.swing.GroupLayout.PREFERRED_SIZE, 632, javax.swing.GroupLayout.PREFERRED_SIZE))))
                .addContainerGap(26, Short.MAX_VALUE))
        );
        jPanel5Layout.setVerticalGroup(
            jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel5Layout.createSequentialGroup()
                .addGap(100, 100, 100)
                .addComponent(jLabel40)
                .addGap(18, 18, 18)
                .addComponent(jScrollPane8, javax.swing.GroupLayout.PREFERRED_SIZE, 94, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(97, 97, 97)
                .addComponent(jLabel41)
                .addGap(18, 18, 18)
                .addComponent(jScrollPane9, javax.swing.GroupLayout.PREFERRED_SIZE, 94, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(224, Short.MAX_VALUE))
        );

        jTabbedPane1.addTab("Encuestas", jPanel5);

        cmdcerrarExalumno.setText("Cerrar");
        cmdcerrarExalumno.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cmdcerrarExalumnoActionPerformed(evt);
            }
        });

        lblUsuario.setFont(new java.awt.Font("Tahoma", 0, 14));
        lblUsuario.setText("jLabel20");

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(lblUsuario, javax.swing.GroupLayout.PREFERRED_SIZE, 257, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(18, 18, 18)
                .addComponent(cmdcerrarExalumno)
                .addContainerGap())
            .addGroup(layout.createSequentialGroup()
                .addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 687, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(cmdcerrarExalumno)
                    .addComponent(lblUsuario))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 701, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
        );

        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void txtDireccionActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtDireccionActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_txtDireccionActionPerformed

    private void txtTipoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_txtTipoActionPerformed
        // TODO add your handling code here:
    }//GEN-LAST:event_txtTipoActionPerformed

    private void cmdLlamarEncuestaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdLlamarEncuestaActionPerformed
        // TODO add your handling code here:
        Conexion conexion = new Conexion();
        try {
            
            int b=conexion.modificarPersona(this.txtCedula.getText(),this.txtNombres.getText(),this.txtApellidos.getText(),this.txtDireccion.getText());
            int c=conexion.modificarPersonaD(this.txtCedula.getText(),this.txtGenero.getText(),this.txtNacionalidad.getText(),this.txtRaza.getText());
            conexion.modificarClave(this.txtCedula.getText(),this.txtContraseña.getText());
            conexion.eliminarTelefonoPersona(this.txtCedula.getText());
            conexion.modificarCiudad(txtCedula.getText(), txtCiudad.getText());
            
             System.out.println(telefonos.size());
            for (int i=0;i< telefonos.size();i++ )
            {
                if(!conexion.buscarTelefono(telefonos.get(i)))
                {
                    conexion.grabarTelefono(telefonos.get(i));
                }
                System.out.println(telefonos.get(i));
                if (telefonos.get(i).equals(txtTPrincipal.getText())){
                    System.out.println("principal");
                    conexion.PersonaTelefono(this.txtCedula.getText(),telefonos.get(i),1); 
                } else {
                    conexion.PersonaTelefono(this.txtCedula.getText(),telefonos.get(i),0); 
                }
            }
            
            
            conexion.eliminarCorreoPersona(this.txtCedula.getText());
            for (int i=0;i< correos.size();i++ )
            {
                if(!conexion.buscarCorreo(correos.get(i))){
                     conexion.grabarCorreo(correos.get(i));
                }
                if (correos.get(i).equals(txtCPrincipal.getText())){
                    conexion.PersonaCorreo(this.txtCedula.getText(),correos.get(i),1); 
                } else {
                    conexion.PersonaCorreo(this.txtCedula.getText(),correos.get(i),0); 
                }
            }
            
            if (b==1 )
            {
                JOptionPane.showMessageDialog(this, "Datos modificados");
                
            }

        } catch (SQLException ex) {
            Logger.getLogger(InterfazAdmin.class.getName()).log(Level.SEVERE, null, ex);
        }
        try {
            ingresarInfoContacto(txtCedula.getText());
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }//GEN-LAST:event_cmdLlamarEncuestaActionPerformed

    private void cmdAgregarTActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdAgregarTActionPerformed
        // TODO add your handling code here:
        
        DefaultTableModel temp = (DefaultTableModel) tablaTelefonos.getModel();
        Object nuevo[] = {this.txttelefono.getText()}; //esto es por las tres columnas aunque puede variar
        temp.addRow(nuevo);
        tablaTelefonos.setModel(temp);
        this.telefonos.add(this.txttelefono.getText());
        this.txttelefono.setText(null);
    }//GEN-LAST:event_cmdAgregarTActionPerformed

    private void cmdeliminarTActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdeliminarTActionPerformed
        // TODO add your handling code here:
        String tel = String.valueOf(tablaTelefonos.getValueAt(tablaTelefonos.getSelectedRow(), 0));

        telefonos.remove(tel);

        DefaultTableModel temp = (DefaultTableModel) tablaTelefonos.getModel();
        for (int i = tablaTelefonos.getRowCount() - 1; i >= 0; i--) {
            temp.removeRow(i);
        }
        for (int i = 0; i < telefonos.size(); i++) {

            Object nuevo[] = {telefonos.get(i)}; //esto es por las tres columnas aunque puede variar

            temp.addRow(nuevo);
        }
        tablaTelefonos.setModel(temp);
    }//GEN-LAST:event_cmdeliminarTActionPerformed

    private void cmdAgregarCActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdAgregarCActionPerformed
        // TODO add your handling code here:
        DefaultTableModel temp = (DefaultTableModel) tablaCorreos.getModel();
        Object nuevo[] = {this.txtcorreo.getText()}; //esto es por las tres columnas aunque puede variar
        temp.addRow(nuevo);
        tablaCorreos.setModel(temp);
        this.correos.add(this.txtcorreo.getText());
        this.txtcorreo.setText(null);
    }//GEN-LAST:event_cmdAgregarCActionPerformed

    private void cmdeliminarCActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdeliminarCActionPerformed
        // TODO add your handling code here:
        String correo = String.valueOf(tablaCorreos.getValueAt(tablaCorreos.getSelectedRow(), 0));
        correos.remove(correo);
        DefaultTableModel temp = (DefaultTableModel) tablaCorreos.getModel();
        for (int i = tablaCorreos.getRowCount() - 1; i >= 0; i--) {
            temp.removeRow(i);
        }
        for (int i = 0; i < correos.size(); i++) {

            Object nuevo[] = {correos.get(i)}; //esto es por las tres columnas aunque puede variar

            temp.addRow(nuevo);
        }
        tablaCorreos.setModel(temp);

    }//GEN-LAST:event_cmdeliminarCActionPerformed

    private void cmdFinalizarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdFinalizarActionPerformed
        // TODO add your handling code here:
        
        //String cargo = String.valueOf(tablaTrabajoActual.getValueAt(tablaTrabajoActual.getSelectedRow(),1));
        //String cedula = txtCedula.getText();
        
        int sel = -3;
        sel = Integer.parseInt(String.valueOf(tablaTrabajoActual.getSelectedRow()));
        if (sel == -1 ){
            JOptionPane.showMessageDialog(this, "Seleccione una fila");
        } else {
        
            fechaFinalizacion.setSize(335, 350);
            fechaFinalizacion.setLocationRelativeTo(this);
            fechaFinalizacion.setModal(true);
            fechaFinalizacion.setVisible(true);
        }
        
    }//GEN-LAST:event_cmdFinalizarActionPerformed

    private void cmdIngresarFechaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdIngresarFechaActionPerformed
        // TODO add your handling code here:
        
        String dia = txtDia.getText();
        String mes = txtMes.getText();
        String anio = txtAnioFin.getText();
             
        String empresa = String.valueOf(tablaTrabajoActual.getValueAt(tablaTrabajoActual.getSelectedRow(),0));
        String cargo = String.valueOf(tablaTrabajoActual.getValueAt(tablaTrabajoActual.getSelectedRow(),1));
        String cedula = txtCedula.getText();
        
        
        
        Exalumno exalumno = new Exalumno();
        try {
            int resultado = exalumno.actualizarTrabajo(cedula, empresa, cargo, dia, mes, anio);
            if (resultado == 1){
                
                JOptionPane.showMessageDialog(this, "Trabajo Actualizado");
                ingresarInformacionLaboral(cedula);
            } else {
                JOptionPane.showMessageDialog(this, "Error al actualizar");
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
       
        fechaFinalizacion.dispose();
    }//GEN-LAST:event_cmdIngresarFechaActionPerformed

    private void cmdIngresarTrabajoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdIngresarTrabajoActionPerformed
        // TODO add your handling code here:
        String cedula = txtCedula.getText();
        String empresa = (String)cbxEmpresa.getSelectedItem();
        String cargo = (String)cbxCargo.getSelectedItem();
        String descripcion = txtDescripcion.getText();
        String dia = txtDia1.getText();
        String mes = txtMes1.getText();
        String anio = txtAnio1.getText();
        
        Exalumno exa = new Exalumno();
        try {
            boolean a = exa.ingresarTrabajoActual(cedula, empresa, cargo, descripcion, dia, mes, anio);
            if (a == true ){
                JOptionPane.showMessageDialog(this, "Error al grabar el nuevo trabajo");
                
            } else {
                JOptionPane.showMessageDialog(this, "Trabajo guardado");
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        try {
            ingresarInformacionLaboral(cedula);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        
        agregarTrabajo.dispose();
        
        
    }//GEN-LAST:event_cmdIngresarTrabajoActionPerformed

    private void cmdAgregarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdAgregarActionPerformed
        // TODO add your handling code here:
        
        cbxEmpresa.removeAllItems();
        Empresa emp = new Empresa();
        Vector<Object> lista = emp.LlenarComboBoxEmpresa();
       
        for(int i=0;i<lista.size();i=i+1)
          {
            Object Item = new Object();
            Item = (lista.get(i).toString());
          
            cbxEmpresa.addItem(Item); 
         }
        
        cbxCargo.removeAllItems();
        Cargo cargo = new Cargo();
        Vector<Object> lista1 = cargo.LlenarComboBoxCargo();
       
        for(int i=0;i<lista1.size();i=i+1)
          {
            Object Item1 = new Object();
            Item1 = (lista1.get(i).toString());
          
            cbxCargo.addItem(Item1); 
         }
        
        agregarTrabajo.setSize(450, 550);
        agregarTrabajo.setLocationRelativeTo(this);
        agregarTrabajo.setModal(true);
        agregarTrabajo.setVisible(true);
        
        
        
        
    }//GEN-LAST:event_cmdAgregarActionPerformed

    private void cmdIngresarEmpresaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdIngresarEmpresaActionPerformed
        // TODO add your handling code here:
        String nombre = txtAEmpresa.getText();
        Empresa emp = new Empresa();
        try {
            boolean a = emp.IngresarEmpresa(nombre);
            if (a == true ){
                JOptionPane.showMessageDialog(this, "Error al grabar empresa");
                
            } else {
                JOptionPane.showMessageDialog(this, "Empresa grabada");
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        
        cbxEmpresa.removeAllItems();
        
        Vector<Object> lista = emp.LlenarComboBoxEmpresa();
       
        for(int i=0;i<lista.size();i=i+1)
          {
            Object Item = new Object();
            Item = (lista.get(i).toString());
          
            cbxEmpresa.addItem(Item); 
         }
        
        agregarEmpresa.dispose();
    }//GEN-LAST:event_cmdIngresarEmpresaActionPerformed

    private void cmdIngresarCargoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdIngresarCargoActionPerformed
        // TODO add your handling code here:
        
        String nombre = txtACargo.getText();
        Cargo cargo = new Cargo();
        try {
            boolean a = cargo.IngresarCargo(nombre);
            if (a == true ){
                JOptionPane.showMessageDialog(this, "Error al grabar cargo");
                
            } else {
                JOptionPane.showMessageDialog(this, "Cargo grabado");
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        
        cbxCargo.removeAllItems();
        Vector<Object> lista1 = cargo.LlenarComboBoxCargo();
       
        for(int i=0;i<lista1.size();i=i+1)
          {
            Object Item1 = new Object();
            Item1 = (lista1.get(i).toString());
          
            cbxCargo.addItem(Item1); 
         }
        
        agregarCargo.dispose();
    }//GEN-LAST:event_cmdIngresarCargoActionPerformed

    private void cmdAEmpresaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdAEmpresaActionPerformed
        // TODO add your handling code here:
        
        agregarEmpresa.setSize(350, 300);
        agregarEmpresa.setLocationRelativeTo(this);
        agregarEmpresa.setModal(true);
        agregarEmpresa.setVisible(true);
    }//GEN-LAST:event_cmdAEmpresaActionPerformed

    private void cmdACargoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdACargoActionPerformed
        // TODO add your handling code here:
        agregarCargo.setSize(350, 300);
        agregarCargo.setLocationRelativeTo(this);
        agregarCargo.setModal(true);
        agregarCargo.setVisible(true);
    }//GEN-LAST:event_cmdACargoActionPerformed

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
        // TODO add your handling code here:
        
        int sel = -3;
        sel = Integer.parseInt(String.valueOf(tablaTrabajoActual.getSelectedRow()));
        if (sel == -1 ){
            JOptionPane.showMessageDialog(this, "Seleccione una fila");
        } else {
        
            String cedula = txtCedula.getText();
            String empresa = String.valueOf(tablaTrabajoActual.getValueAt(tablaTrabajoActual.getSelectedRow(),0));
            String cargo = String.valueOf(tablaTrabajoActual.getValueAt(tablaTrabajoActual.getSelectedRow(),1));
            
            Exalumno exa = new Exalumno();
            try {
            boolean a = exa.eliminarTrabajo(cedula, empresa, cargo);
            if (a == true ){
                JOptionPane.showMessageDialog(this, "Error al eliminar");
                
            } else {
                JOptionPane.showMessageDialog(this, "Trabajo Eliminado");
                ingresarInformacionLaboral(cedula);
            }
            } catch (SQLException ex) {
            ex.printStackTrace();
            }
            
            
        }
    }//GEN-LAST:event_jButton2ActionPerformed

    private void cmdeditarSecundariosActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdeditarSecundariosActionPerformed
        // TODO add your handling code here:
        
        Exalumno exa = new Exalumno();
        cbxColegio.removeAllItems();
        Vector<Object> lista1 = exa.LlenarComboBoxColegio();
       
        for(int i=0;i<lista1.size();i=i+1)
          {
            Object Item1 = new Object();
            Item1 = (lista1.get(i).toString());
          
            cbxColegio.addItem(Item1); 
         }
        
        cbxPromedioC.removeAllItems();
        cbxPromedioC.addItem("SOBRESALIENTE (19 - 20) (90-100)");
        cbxPromedioC.addItem("MUY BUENA (18  - <19) (80 - <90)");
        cbxPromedioC.addItem("BUENA (17  - <18) (70 - <80)");
        cbxPromedioC.addItem("REGULAR (16  - <17) (60 - <70)");
        
        cambiarInstitucion.setSize(350, 300);
        cambiarInstitucion.setLocationRelativeTo(this);
        cambiarInstitucion.setModal(true);
        cambiarInstitucion.setVisible(true);
        
    }//GEN-LAST:event_cmdeditarSecundariosActionPerformed

    private void cmdAgregarColegioActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdAgregarColegioActionPerformed
        // TODO add your handling code here:
        agregarColegio.setSize(350, 300);
        agregarColegio.setLocationRelativeTo(this);
        agregarColegio.setModal(true);
        agregarColegio.setVisible(true);
      
    }//GEN-LAST:event_cmdAgregarColegioActionPerformed

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed
        // TODO add your handling code here:
        
        String nombre = txtAColegio.getText();
        Exalumno emp = new Exalumno();
        try {
            boolean a = emp.IngresarColegio(nombre);
            if (a == true ){
                JOptionPane.showMessageDialog(this, "Error al grabar colegio");
                
            } else {
                JOptionPane.showMessageDialog(this, "Colegio guardado");
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        
        cbxColegio.removeAllItems();
        
        Vector<Object> lista = emp.LlenarComboBoxColegio();
       
        for(int i=0;i<lista.size();i=i+1)
          {
            Object Item = new Object();
            Item = (lista.get(i).toString());
          
            cbxColegio.addItem(Item); 
         }
        
        agregarColegio.dispose();
    }//GEN-LAST:event_jButton3ActionPerformed

    private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton4ActionPerformed
        // TODO add your handling code here:
        
        String nombre = (String)cbxColegio.getSelectedItem();
        String promedio = (String)cbxPromedioC.getSelectedItem();
        
        txtInstitucion.setText(nombre);
        txtPromedioI.setText(promedio);
        
        cambiarInstitucion.dispose();
        
    }//GEN-LAST:event_jButton4ActionPerformed

    private void cmdcerrarExalumnoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdcerrarExalumnoActionPerformed
       if(bandUsuario==1){
        this.dispose();}
       else
       {
           Principal principal=new Principal();
        principal.setVisible(true);
        this.dispose();
       }
       Conexion log = new Conexion();
        try
        {
            log.ingersarLog(cedulaActual, "SALIO EXALUMNO");
        } 
        catch (SQLException ex) 
        {
            Logger.getLogger(InterfazAdmin.class.getName()).log(Level.SEVERE, null, ex);
        }
       
    }//GEN-LAST:event_cmdcerrarExalumnoActionPerformed

    private void cmdBuscarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdBuscarActionPerformed
        try {
            cargarDatos(this.txtCedula.getText());
        } catch (SQLException ex) {
            Logger.getLogger(InterfazExAlumno.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_cmdBuscarActionPerformed

    private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton7ActionPerformed
        // TODO add your handling code here:
        cbxGenero.removeAllItems();
        cbxGenero.addItem("MASCULINO");
        cbxGenero.addItem("FEMENINO");
                
        cambiarGenero.setSize(350, 300);
        cambiarGenero.setLocationRelativeTo(this);
        cambiarGenero.setModal(true);
        cambiarGenero.setVisible(true);
    }//GEN-LAST:event_jButton7ActionPerformed

    private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton8ActionPerformed
        // TODO add your handling code here:
        cbxNacionalidad.removeAllItems();
        Conexion exa = new Conexion();
       
        Vector<Object> lista1 = exa.LlenarComboBoxNacionalidad();
       
        for(int i=0;i<lista1.size();i=i+1)
          {
            Object Item1 = new Object();
            Item1 = (lista1.get(i).toString());
          
            cbxNacionalidad.addItem(Item1); 
         }
                
        cambiarNacionalidad.setSize(350, 300);
        cambiarNacionalidad.setLocationRelativeTo(this);
        cambiarNacionalidad.setModal(true);
        cambiarNacionalidad.setVisible(true);
    }//GEN-LAST:event_jButton8ActionPerformed

    private void jButton9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton9ActionPerformed
        // TODO add your handling code here:
        cbxEtnia.removeAllItems();
        Conexion exa = new Conexion();
       
        Vector<Object> lista1 = exa.LlenarComboBoxEtnia();
       
        for(int i=0;i<lista1.size();i=i+1)
          {
            Object Item1 = new Object();
            Item1 = (lista1.get(i).toString());
          
            cbxEtnia.addItem(Item1); 
         }
                
        cambiarEtnia.setSize(350, 300);
        cambiarEtnia.setLocationRelativeTo(this);
        cambiarEtnia.setModal(true);
        cambiarEtnia.setVisible(true);
    }//GEN-LAST:event_jButton9ActionPerformed

    private void jButton11ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton11ActionPerformed
        // TODO add your handling code here:
        String nombre = txtANacionalidad.getText().toUpperCase();
        Conexion per = new Conexion();
        try {
            boolean a = per.IngresarNacionalidad(nombre);
            if (a == true ){
                JOptionPane.showMessageDialog(this, "Error al grabar nacionalidad");
                
            } else {
                JOptionPane.showMessageDialog(this, "Nacionalidad guardada");
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        txtANacionalidad.setText("");
        cbxNacionalidad.removeAllItems();
        
        Vector<Object> lista = per.LlenarComboBoxNacionalidad();
       
        for(int i=0;i<lista.size();i=i+1)
          {
            Object Item = new Object();
            Item = (lista.get(i).toString());
          
            cbxNacionalidad.addItem(Item); 
         }
    }//GEN-LAST:event_jButton11ActionPerformed

    private void jButton13ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton13ActionPerformed
        // TODO add your handling code here:
        String nombre = txtAEtnia.getText().toUpperCase();
        Conexion per = new Conexion();
        try {
            boolean a = per.IngresarEtnia(nombre);
            if (a == true ){
                JOptionPane.showMessageDialog(this, "Error al grabar etnia");
                
            } else {
                JOptionPane.showMessageDialog(this, "Etnia guardada");
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        txtAEtnia.setText("");
        cbxEtnia.removeAllItems();
        
        Vector<Object> lista = per.LlenarComboBoxEtnia();
       
        for(int i=0;i<lista.size();i=i+1)
          {
            Object Item = new Object();
            Item = (lista.get(i).toString());
          
            cbxEtnia.addItem(Item); 
         }
    }//GEN-LAST:event_jButton13ActionPerformed

    private void jButton10ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton10ActionPerformed
        // TODO add your handling code here:
        
        txtGenero.setText((String)cbxGenero.getSelectedItem());
        cambiarGenero.dispose();
    }//GEN-LAST:event_jButton10ActionPerformed

    private void jButton12ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton12ActionPerformed
        // TODO add your handling code here:
        txtNacionalidad.setText((String)cbxNacionalidad.getSelectedItem());
        cambiarNacionalidad.dispose();
    }//GEN-LAST:event_jButton12ActionPerformed

    private void jButton14ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton14ActionPerformed
        // TODO add your handling code here:
        txtRaza.setText((String)cbxEtnia.getSelectedItem());
        cambiarEtnia.dispose();
    }//GEN-LAST:event_jButton14ActionPerformed

    private void jButton17ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton17ActionPerformed
        // TODO add your handling code here:
       
        int sel = -3;
        sel = Integer.parseInt(String.valueOf(tablaTelefonos.getSelectedRow()));
        if (sel == -1 ){
            JOptionPane.showMessageDialog(this, "Seleccione una fila");
        } else {
            txtTPrincipal.setText(String.valueOf(tablaTelefonos.getValueAt(tablaTelefonos.getSelectedRow(), 0)));
            
        }
    }//GEN-LAST:event_jButton17ActionPerformed

    private void jButton18ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton18ActionPerformed
        // TODO add your handling code here:
        int sel = -3;
        sel = Integer.parseInt(String.valueOf(tablaCorreos.getSelectedRow()));
        if (sel == -1 ){
            JOptionPane.showMessageDialog(this, "Seleccione una fila");
        } else {
            txtCPrincipal.setText(String.valueOf(tablaCorreos.getValueAt(tablaCorreos.getSelectedRow(), 0)));
            
        }
    }//GEN-LAST:event_jButton18ActionPerformed

    private void jButton19ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton19ActionPerformed
        try {
            // TODO add your handling code here:
            ingresarDatosPersonales(txtCedula.getText());
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }//GEN-LAST:event_jButton19ActionPerformed

    private void jButton15ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton15ActionPerformed
        // TODO add your handling code here:
        String tipo = (String)cbxTipoContacto.getSelectedItem();
        
        if (tipo.equals("TELEFONO")){
            txttelefono1.setEditable(true);
            cmdAgregarT1.setEnabled(true);
            cmdeliminarT1.setEnabled(true);
            jButton20.setEnabled(true);
            txtcorreo1.setEditable(false);
            cmdAgregarC1.setEnabled(false);
            cmdeliminarC1.setEnabled(false);
            jButton21.setEnabled(false);
            txtOtro.setEditable(false);
        }
        
        if (tipo.equals("CORREO")){
            txtcorreo1.setEditable(true);
            cmdAgregarC1.setEnabled(true);
            cmdeliminarC1.setEnabled(true);
            jButton21.setEnabled(true);
            txttelefono1.setEditable(false);
            cmdAgregarT1.setEnabled(false);
            cmdeliminarT1.setEnabled(false);
            jButton20.setEnabled(false);
            txtOtro.setEditable(false);
        }
        
        if (tipo.equals("OTRO")){
            txtOtro.setEditable(true);
            txtcorreo1.setEditable(false);
            cmdAgregarC1.setEnabled(false);
            cmdeliminarC1.setEnabled(false);
            jButton21.setEnabled(false);
            txttelefono1.setEditable(false);
            cmdAgregarT1.setEnabled(false);
            cmdeliminarT1.setEnabled(false);
            jButton20.setEnabled(false);
        }
        cmdConfTipo.setEnabled(true);
        
    }//GEN-LAST:event_jButton15ActionPerformed

    private void jButton20ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton20ActionPerformed
        // TODO add your handling code here:
        int sel = -3;
        sel = Integer.parseInt(String.valueOf(tablaTelefonos1.getSelectedRow()));
        if (sel == -1 ){
            JOptionPane.showMessageDialog(this, "Seleccione una fila");
        } else {
            txtTPrincipal1.setText(String.valueOf(tablaTelefonos1.getValueAt(tablaTelefonos1.getSelectedRow(), 0)));
            
        }
    }//GEN-LAST:event_jButton20ActionPerformed

    private void jButton21ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton21ActionPerformed
        // TODO add your handling code here:
        int sel = -3;
        sel = Integer.parseInt(String.valueOf(tablaCorreos1.getSelectedRow()));
        if (sel == -1 ){
            JOptionPane.showMessageDialog(this, "Seleccione una fila");
        } else {
            txtCPrincipal1.setText(String.valueOf(tablaCorreos1.getValueAt(tablaCorreos1.getSelectedRow(), 0)));
            
        }
    }//GEN-LAST:event_jButton21ActionPerformed

    private void cmdeliminarC1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdeliminarC1ActionPerformed
        // TODO add your handling code here:
        String correo = String.valueOf(tablaCorreos1.getValueAt(tablaCorreos1.getSelectedRow(), 0));
        correos.remove(correo);
        DefaultTableModel temp = (DefaultTableModel) tablaCorreos1.getModel();
        for (int i = tablaCorreos1.getRowCount() - 1; i >= 0; i--) {
            temp.removeRow(i);
        }
        for (int i = 0; i < correos.size(); i++) {

            Object nuevo[] = {correos.get(i)}; //esto es por las tres columnas aunque puede variar

            temp.addRow(nuevo);
        }
        tablaCorreos1.setModel(temp);
    }//GEN-LAST:event_cmdeliminarC1ActionPerformed

    private void cmdAgregarC1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdAgregarC1ActionPerformed
        // TODO add your handling code here:
        DefaultTableModel temp = (DefaultTableModel) tablaCorreos1.getModel();
        Object nuevo[] = {this.txtcorreo1.getText()}; //esto es por las tres columnas aunque puede variar
        temp.addRow(nuevo);
        tablaCorreos1.setModel(temp);
        this.correos.add(this.txtcorreo1.getText());
        this.txtcorreo1.setText(null);
    }//GEN-LAST:event_cmdAgregarC1ActionPerformed

    private void cmdeliminarT1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdeliminarT1ActionPerformed
        // TODO add your handling code here:
         String tel = String.valueOf(tablaTelefonos1.getValueAt(tablaTelefonos1.getSelectedRow(), 0));

        telefonos.remove(tel);

        DefaultTableModel temp = (DefaultTableModel) tablaTelefonos1.getModel();
        for (int i = tablaTelefonos1.getRowCount() - 1; i >= 0; i--) {
            temp.removeRow(i);
        }
        for (int i = 0; i < telefonos.size(); i++) {

            Object nuevo[] = {telefonos.get(i)}; //esto es por las tres columnas aunque puede variar

            temp.addRow(nuevo);
        }
        tablaTelefonos1.setModel(temp);
    }//GEN-LAST:event_cmdeliminarT1ActionPerformed

    private void cmdAgregarT1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdAgregarT1ActionPerformed
        // TODO add your handling code here:
        DefaultTableModel temp = (DefaultTableModel) tablaTelefonos1.getModel();
        Object nuevo[] = {this.txttelefono1.getText()}; //esto es por las tres columnas aunque puede variar
        temp.addRow(nuevo);
        tablaTelefonos1.setModel(temp);
        this.telefonos.add(this.txttelefono1.getText());
        this.txttelefono1.setText(null);
        
    }//GEN-LAST:event_cmdAgregarT1ActionPerformed

    private void cmdConfTipoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdConfTipoActionPerformed
        // TODO add your handling code here:
        Conexion conexion = new Conexion();
        String tipo = (String)cbxTipoContacto.getSelectedItem();
        int met ;
        if (tipo.equals("TELEFONO")){
            try {
                conexion.eliminarTelefonoPersona(this.txtCedula.getText());
            
            
             System.out.println(telefonos.size());
            for (int i=0;i< telefonos.size();i++ )
            {
                if(!conexion.buscarTelefono(telefonos.get(i)))
                {
                    conexion.grabarTelefono(telefonos.get(i));
                }
                System.out.println(telefonos.get(i));
                if (telefonos.get(i).equals(txtTPrincipal1.getText())){
                    System.out.println("principal");
                    conexion.PersonaTelefono(this.txtCedula.getText(),telefonos.get(i),1); 
                } else {
                    conexion.PersonaTelefono(this.txtCedula.getText(),telefonos.get(i),0); 
                }
            }
            met=conexion.actualizarMetodo(txtCedula.getText(),1);
            
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
            
            
            
        }
        
        if (tipo.equals("CORREO")){
            try {
                conexion.eliminarCorreoPersona(this.txtCedula.getText());
            
            for (int i=0;i< correos.size();i++ )
            {
                if(!conexion.buscarCorreo(correos.get(i))){
                     conexion.grabarCorreo(correos.get(i));
                }
                if (correos.get(i).equals(txtCPrincipal1.getText())){
                    conexion.PersonaCorreo(this.txtCedula.getText(),correos.get(i),1); 
                } else {
                    conexion.PersonaCorreo(this.txtCedula.getText(),correos.get(i),0); 
                }
            }
            met=conexion.actualizarMetodo(txtCedula.getText(),2);
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
        
        if (tipo.equals("OTRO")){
            try {
                int otro = conexion.tipoOtro(this.txtCedula.getText(), txtOtro.getText());
                met=conexion.actualizarMetodo(txtCedula.getText(),3);
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
        try {
            ingresarInfoContacto(txtCedula.getText());
            ingresarDatosPersonales(txtCedula.getText());
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        
            txtOtro.setEditable(false);
            txtcorreo1.setEditable(false);
            cmdAgregarC1.setEnabled(false);
            cmdeliminarC1.setEnabled(false);
            jButton21.setEnabled(false);
            txttelefono1.setEditable(false);
            cmdAgregarT1.setEnabled(false);
            cmdeliminarT1.setEnabled(false);
            jButton20.setEnabled(false);
            cmdConfTipo.setEnabled(false);
            
    }//GEN-LAST:event_cmdConfTipoActionPerformed

    private void jButton22ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton22ActionPerformed
        // TODO add your handling code here:
        String ciudad=this.txtACiudad.getText();
        Conexion conexion=new Conexion();
        try {
            conexion.agregarCiudad(ciudad);

        this.cmbCiudad.removeAllItems();
        this.cmbCiudad.addItem("Elija una ciudad...");
        ArrayList lista=conexion.listarCiudades();
        for (int i=0; i<lista.size();i++)
        {
            this.cmbCiudad.addItem(lista.get(i));         
            
        }
        } catch (SQLException ex) {
            Logger.getLogger(InterfazAdmin.class.getName()).log(Level.SEVERE, null, ex);
        }
        txtACiudad.setText("");
    }//GEN-LAST:event_jButton22ActionPerformed

    private void jButton24ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton24ActionPerformed
        // TODO add your handling code here:
        cambiarCiudad.dispose();
    }//GEN-LAST:event_jButton24ActionPerformed

    private void jButton23ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton23ActionPerformed
        // TODO add your handling code here:
        txtCiudad.setText((String)cmbCiudad.getSelectedItem());
        cambiarCiudad.dispose();
    }//GEN-LAST:event_jButton23ActionPerformed

    private void jButton16ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton16ActionPerformed
        // TODO add your handling code here:
        cambiarCiudad.setSize(350, 300);
        cambiarCiudad.setLocationRelativeTo(this);
        cambiarCiudad.setModal(true);
        cambiarCiudad.setVisible(true);
    }//GEN-LAST:event_jButton16ActionPerformed

    private void jButton25ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton25ActionPerformed
        // TODO add your handling code here:
        cambiarEtnia.dispose();
    }//GEN-LAST:event_jButton25ActionPerformed

    private void jButton26ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton26ActionPerformed
        // TODO add your handling code here:
        cambiarNacionalidad.dispose();
    }//GEN-LAST:event_jButton26ActionPerformed

    private void jButton27ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton27ActionPerformed
        // TODO add your handling code here:
        cambiarGenero.dispose();
    }//GEN-LAST:event_jButton27ActionPerformed

    private void jButton29ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton29ActionPerformed
        // TODO add your handling code here:
        agregarColegio.dispose();
    }//GEN-LAST:event_jButton29ActionPerformed

    private void jButton30ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton30ActionPerformed
        // TODO add your handling code here:
        cambiarInstitucion.dispose();
    }//GEN-LAST:event_jButton30ActionPerformed

    private void jButton31ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton31ActionPerformed
        // TODO add your handling code here:
        agregarCargo.dispose();
    }//GEN-LAST:event_jButton31ActionPerformed

    private void jButton32ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton32ActionPerformed
        // TODO add your handling code here:
        agregarEmpresa.dispose();
    }//GEN-LAST:event_jButton32ActionPerformed

    private void jButton33ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton33ActionPerformed
        // TODO add your handling code here:
        agregarTrabajo.dispose();
    }//GEN-LAST:event_jButton33ActionPerformed

    private void jButton34ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton34ActionPerformed
        // TODO add your handling code here:
        fechaFinalizacion.dispose();
    }//GEN-LAST:event_jButton34ActionPerformed

    private void jButton35ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton35ActionPerformed
        // TODO add your handling code here:
        // Para guardar el colegio y el promedio
        String cedula = txtCedula.getText();
        String nombre = txtInstitucion.getText();
        String promedio = txtPromedioI.getText();
        
        Exalumno exa = new Exalumno();
        try {
            int a = exa.actualizarColegio(cedula, nombre, promedio);
            String repres = (String)cbxRepresentante.getSelectedItem();
        int b = exa.actualizarRepresentante(cedula, repres);
            
        } catch (SQLException ex) {
        ex.printStackTrace();
        }
        
        
        try {
            ingresarInformacionAcademica(cedula);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        
    }//GEN-LAST:event_jButton35ActionPerformed

    private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton5ActionPerformed
        // TODO add your handling code here:
        int sel = -3;
        sel = Integer.parseInt(String.valueOf(tablaTitulosUCuenca.getSelectedRow()));
        if (sel == -1 ){
            JOptionPane.showMessageDialog(this, "Seleccione una fila");
        } else {
            
            Conexion con = new Conexion();
            
            
            txtAnioGraduacion.setText((String)tablaTitulosUCuenca.getValueAt(tablaTitulosUCuenca.getSelectedRow(), 3));
        
            Vector<Object> lista = con.LlenarComboBoxFacultad();
            cbxFacultad.removeAllItems(); 
        for(int i=0;i<lista.size();i=i+1)
          {
            Object Item = new Object();
            Item = (lista.get(i).toString());
          
            cbxFacultad.addItem(Item); 
         }
         
            
        cbxPromedioU.removeAllItems();
        cbxPromedioU.addItem("SOBRESALIENTE (19 - 20) (90-100)");
        cbxPromedioU.addItem("MUY BUENA (18  - <19) (80 - <90)");
        cbxPromedioU.addItem("BUENA (17  - <18) (70 - <80)");
        cbxPromedioU.addItem("REGULAR (16  - <17) (60 - <70)");
        
        bGuardar.setEnabled(false);
        bEditar.setEnabled(true);
            editarUniversidad.setSize(335, 350);
            editarUniversidad.setLocationRelativeTo(this);
            editarUniversidad.setModal(true);
            editarUniversidad.setVisible(true);
        }
        
    }//GEN-LAST:event_jButton5ActionPerformed

    private void jButton28ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton28ActionPerformed
        // TODO add your handling code here:
        editarUniversidad.dispose();
    }//GEN-LAST:event_jButton28ActionPerformed

    private void cbxFacultadActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cbxFacultadActionPerformed
        // TODO add your handling code here:
        Conexion conexion=new Conexion();
        ArrayList lista;
        try {
            lista=conexion.listarEscuelas(String.valueOf(this.cbxFacultad.getSelectedItem()));
            this.cbxEscuela.removeAllItems();
            for (int i=0; i<lista.size();i++)
            {
                this.cbxEscuela.addItem(lista.get(i));
            } 
            
        } catch (SQLException ex) {
            Logger.getLogger(InterfazAdmin.class.getName()).log(Level.SEVERE, null, ex);
        }
    }//GEN-LAST:event_cbxFacultadActionPerformed

    private void bEditarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_bEditarActionPerformed
        // TODO add your handling code here:
        String cedula = txtCedula.getText();
        String facultad = (String)cbxFacultad.getSelectedItem();
        String escuela = (String)cbxEscuela.getSelectedItem();
        String titulo = (String)cbxTitulo.getSelectedItem();
        String graduacion = txtAnioGraduacion.getText();
        String nota = (String)cbxPromedioU.getSelectedItem();
        
        Exalumno exa = new Exalumno();
        try {
            exa.actualizarUniversidad(cedula, facultad, escuela, titulo, graduacion, nota);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        editarUniversidad.dispose();
    }//GEN-LAST:event_bEditarActionPerformed

    private void cbxEscuelaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cbxEscuelaActionPerformed
        // TODO add your handling code here:
        
       
    }//GEN-LAST:event_cbxEscuelaActionPerformed

    private void cbxEscuelaMouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_cbxEscuelaMouseClicked
        // TODO add your handling code here:
         Conexion con = new Conexion();
        Vector<Object> lista1 = con.LlenarComboBoxTitulo(String.valueOf(this.cbxEscuela.getSelectedItem()));
            cbxTitulo.removeAllItems(); 
        for(int i=0;i<lista1.size();i=i+1)
          {
            Object Item = new Object();
            Item = (lista1.get(i).toString());
          
            cbxTitulo.addItem(Item); 
         }
    }//GEN-LAST:event_cbxEscuelaMouseClicked

    private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton6ActionPerformed
        // TODO add your handling code here:
        Conexion con = new Conexion();
        Vector<Object> lista = con.LlenarComboBoxFacultad();
            cbxFacultad.removeAllItems(); 
        for(int i=0;i<lista.size();i=i+1)
          {
            Object Item = new Object();
            Item = (lista.get(i).toString());
          
            cbxFacultad.addItem(Item); 
         }
         
            
        cbxPromedioU.removeAllItems();
        cbxPromedioU.addItem("SOBRESALIENTE (19 - 20) (90-100)");
        cbxPromedioU.addItem("MUY BUENA (18  - <19) (80 - <90)");
        cbxPromedioU.addItem("BUENA (17  - <18) (70 - <80)");
        cbxPromedioU.addItem("REGULAR (16  - <17) (60 - <70)");
        
        bEditar.setEnabled(false);
        bGuardar.setEnabled(true);
            editarUniversidad.setSize(335, 350);
            editarUniversidad.setLocationRelativeTo(this);
            editarUniversidad.setModal(true);
            editarUniversidad.setVisible(true);
    }//GEN-LAST:event_jButton6ActionPerformed

    private void bGuardarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_bGuardarActionPerformed
        // TODO add your handling code here:
        String cedula = txtCedula.getText();
        String facultad = (String)cbxFacultad.getSelectedItem();
        String escuela = (String)cbxEscuela.getSelectedItem();
        String titulo = (String)cbxTitulo.getSelectedItem();
        String graduacion = txtAnioGraduacion.getText();
        String nota = (String)cbxPromedioU.getSelectedItem();
        
        Exalumno exa = new Exalumno();
        try {
            exa.ingresarUniversidad(cedula, facultad, escuela, titulo, graduacion, nota);
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        editarUniversidad.dispose();
    }//GEN-LAST:event_bGuardarActionPerformed

    
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        /* Set the Nimbus look and feel */
        //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
        /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
         * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html 
         */
        try {
            for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
                if ("Nimbus".equals(info.getName())) {
                    javax.swing.UIManager.setLookAndFeel(info.getClassName());
                    break;
                }
            }
        } catch (ClassNotFoundException ex) {
            java.util.logging.Logger.getLogger(InterfazExAlumno.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (InstantiationException ex) {
            java.util.logging.Logger.getLogger(InterfazExAlumno.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (IllegalAccessException ex) {
            java.util.logging.Logger.getLogger(InterfazExAlumno.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        } catch (javax.swing.UnsupportedLookAndFeelException ex) {
            java.util.logging.Logger.getLogger(InterfazExAlumno.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
        }
        //</editor-fold>

        /* Create and display the form */
        java.awt.EventQueue.invokeLater(new Runnable() {

            public void run() {
                try {
                    new InterfazExAlumno().setVisible(true);
                } catch (SQLException ex) {
                    ex.printStackTrace();
                }
            }
        });
    }
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JDialog agregarCargo;
    private javax.swing.JDialog agregarColegio;
    private javax.swing.JDialog agregarEmpresa;
    private javax.swing.JDialog agregarTrabajo;
    private javax.swing.JButton bEditar;
    private javax.swing.JButton bGuardar;
    private javax.swing.JDialog cambiarCiudad;
    private javax.swing.JDialog cambiarEtnia;
    private javax.swing.JDialog cambiarGenero;
    private javax.swing.JDialog cambiarInstitucion;
    private javax.swing.JDialog cambiarNacionalidad;
    private javax.swing.JComboBox cbxCargo;
    private javax.swing.JComboBox cbxColegio;
    private javax.swing.JComboBox cbxEmpresa;
    private javax.swing.JComboBox cbxEscuela;
    private javax.swing.JComboBox cbxEtnia;
    private javax.swing.JComboBox cbxFacultad;
    private javax.swing.JComboBox cbxGenero;
    private javax.swing.JComboBox cbxNacionalidad;
    private javax.swing.JComboBox cbxPromedioC;
    private javax.swing.JComboBox cbxPromedioU;
    private javax.swing.JComboBox cbxRepresentante;
    private javax.swing.JComboBox cbxTipoContacto;
    private javax.swing.JComboBox cbxTitulo;
    private javax.swing.JComboBox cmbCiudad;
    private javax.swing.JButton cmdACargo;
    private javax.swing.JButton cmdAEmpresa;
    private javax.swing.JButton cmdAgregar;
    private javax.swing.JButton cmdAgregarC;
    private javax.swing.JButton cmdAgregarC1;
    private javax.swing.JButton cmdAgregarColegio;
    private javax.swing.JButton cmdAgregarT;
    private javax.swing.JButton cmdAgregarT1;
    private javax.swing.JButton cmdBuscar;
    private javax.swing.JButton cmdConfTipo;
    private javax.swing.JButton cmdFinalizar;
    private javax.swing.JButton cmdIngresarCargo;
    private javax.swing.JButton cmdIngresarEmpresa;
    private javax.swing.JButton cmdIngresarFecha;
    private javax.swing.JButton cmdIngresarTrabajo;
    private javax.swing.JButton cmdLlamarEncuesta;
    private javax.swing.JButton cmdcerrarExalumno;
    private javax.swing.JButton cmdeditarSecundarios;
    private javax.swing.JButton cmdeliminarC;
    private javax.swing.JButton cmdeliminarC1;
    private javax.swing.JButton cmdeliminarT;
    private javax.swing.JButton cmdeliminarT1;
    private javax.swing.JDialog editarUniversidad;
    private javax.swing.JDialog fechaFinalizacion;
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton10;
    private javax.swing.JButton jButton11;
    private javax.swing.JButton jButton12;
    private javax.swing.JButton jButton13;
    private javax.swing.JButton jButton14;
    private javax.swing.JButton jButton15;
    private javax.swing.JButton jButton16;
    private javax.swing.JButton jButton17;
    private javax.swing.JButton jButton18;
    private javax.swing.JButton jButton19;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton20;
    private javax.swing.JButton jButton21;
    private javax.swing.JButton jButton22;
    private javax.swing.JButton jButton23;
    private javax.swing.JButton jButton24;
    private javax.swing.JButton jButton25;
    private javax.swing.JButton jButton26;
    private javax.swing.JButton jButton27;
    private javax.swing.JButton jButton28;
    private javax.swing.JButton jButton29;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton30;
    private javax.swing.JButton jButton31;
    private javax.swing.JButton jButton32;
    private javax.swing.JButton jButton33;
    private javax.swing.JButton jButton34;
    private javax.swing.JButton jButton35;
    private javax.swing.JButton jButton36;
    private javax.swing.JButton jButton4;
    private javax.swing.JButton jButton5;
    private javax.swing.JButton jButton6;
    private javax.swing.JButton jButton7;
    private javax.swing.JButton jButton8;
    private javax.swing.JButton jButton9;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel17;
    private javax.swing.JLabel jLabel18;
    private javax.swing.JLabel jLabel19;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel20;
    private javax.swing.JLabel jLabel21;
    private javax.swing.JLabel jLabel22;
    private javax.swing.JLabel jLabel23;
    private javax.swing.JLabel jLabel24;
    private javax.swing.JLabel jLabel25;
    private javax.swing.JLabel jLabel26;
    private javax.swing.JLabel jLabel27;
    private javax.swing.JLabel jLabel28;
    private javax.swing.JLabel jLabel29;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel30;
    private javax.swing.JLabel jLabel31;
    private javax.swing.JLabel jLabel32;
    private javax.swing.JLabel jLabel33;
    private javax.swing.JLabel jLabel34;
    private javax.swing.JLabel jLabel35;
    private javax.swing.JLabel jLabel36;
    private javax.swing.JLabel jLabel37;
    private javax.swing.JLabel jLabel38;
    private javax.swing.JLabel jLabel39;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel40;
    private javax.swing.JLabel jLabel41;
    private javax.swing.JLabel jLabel42;
    private javax.swing.JLabel jLabel43;
    private javax.swing.JLabel jLabel44;
    private javax.swing.JLabel jLabel45;
    private javax.swing.JLabel jLabel46;
    private javax.swing.JLabel jLabel47;
    private javax.swing.JLabel jLabel48;
    private javax.swing.JLabel jLabel49;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel50;
    private javax.swing.JLabel jLabel51;
    private javax.swing.JLabel jLabel52;
    private javax.swing.JLabel jLabel53;
    private javax.swing.JLabel jLabel54;
    private javax.swing.JLabel jLabel55;
    private javax.swing.JLabel jLabel56;
    private javax.swing.JLabel jLabel57;
    private javax.swing.JLabel jLabel58;
    private javax.swing.JLabel jLabel59;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel60;
    private javax.swing.JLabel jLabel61;
    private javax.swing.JLabel jLabel62;
    private javax.swing.JLabel jLabel63;
    private javax.swing.JLabel jLabel64;
    private javax.swing.JLabel jLabel65;
    private javax.swing.JLabel jLabel66;
    private javax.swing.JLabel jLabel67;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JList jList1;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JPanel jPanel4;
    private javax.swing.JPanel jPanel5;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane10;
    private javax.swing.JScrollPane jScrollPane11;
    private javax.swing.JScrollPane jScrollPane12;
    private javax.swing.JScrollPane jScrollPane13;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JScrollPane jScrollPane4;
    private javax.swing.JScrollPane jScrollPane5;
    private javax.swing.JScrollPane jScrollPane6;
    private javax.swing.JScrollPane jScrollPane7;
    private javax.swing.JScrollPane jScrollPane8;
    private javax.swing.JScrollPane jScrollPane9;
    private javax.swing.JSeparator jSeparator1;
    private javax.swing.JSeparator jSeparator2;
    private javax.swing.JSeparator jSeparator3;
    private javax.swing.JTabbedPane jTabbedPane1;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JLabel lblUsuario;
    private javax.swing.JTable tablaCorreos;
    private javax.swing.JTable tablaCorreos1;
    private javax.swing.JTable tablaEncuestas;
    private javax.swing.JTable tablaEncuestasLLenar;
    private javax.swing.JTable tablaEstudiosAvanzados1;
    private javax.swing.JTable tablaHistorialTrabajo;
    private javax.swing.JTable tablaRepresentante;
    private javax.swing.JTable tablaTelefonos;
    private javax.swing.JTable tablaTelefonos1;
    private javax.swing.JTable tablaTitulosUCuenca;
    private javax.swing.JTable tablaTitulosUniversidades;
    private javax.swing.JTable tablaTrabajoActual;
    private javax.swing.JTextField txtACargo;
    private javax.swing.JTextField txtACiudad;
    private javax.swing.JTextField txtAColegio;
    private javax.swing.JTextField txtAEmpresa;
    private javax.swing.JTextField txtAEtnia;
    private javax.swing.JTextField txtANacionalidad;
    private javax.swing.JTextField txtAnio1;
    private javax.swing.JTextField txtAnioFin;
    private javax.swing.JTextField txtAnioGraduacion;
    private javax.swing.JTextField txtApellidos;
    private javax.swing.JTextField txtCPrincipal;
    private javax.swing.JTextField txtCPrincipal1;
    private javax.swing.JTextField txtCedula;
    private javax.swing.JTextField txtCiudad;
    private javax.swing.JTextField txtContacto;
    private javax.swing.JTextField txtContraseña;
    private javax.swing.JTextField txtDescripcion;
    private javax.swing.JTextField txtDia;
    private javax.swing.JTextField txtDia1;
    private javax.swing.JTextField txtDireccion;
    private javax.swing.JTextField txtGenero;
    private javax.swing.JTextField txtInstitucion;
    private javax.swing.JTextField txtMes;
    private javax.swing.JTextField txtMes1;
    private javax.swing.JTextField txtNacionalidad;
    private javax.swing.JTextField txtNombres;
    private javax.swing.JTextField txtOtro;
    private javax.swing.JTextField txtPromedioI;
    private javax.swing.JTextField txtRaza;
    private javax.swing.JTextField txtTPrincipal;
    private javax.swing.JTextField txtTPrincipal1;
    private javax.swing.JTextField txtTipo;
    private javax.swing.JTextField txtcorreo;
    private javax.swing.JTextField txtcorreo1;
    private javax.swing.JTextField txttelefono;
    private javax.swing.JTextField txttelefono1;
    // End of variables declaration//GEN-END:variables

    public void enviarCedula(String cedula,int band) throws SQLException {
        this.cedulaActual=cedula;
        Conexion conexion=new Conexion();
        Conexion log = new Conexion();
        bandUsuario=band;
        if(bandUsuario==3)
        {
            cargarDatos(cedula);
            this.cmdBuscar.setText("Cerrar sesion");
            this.lblUsuario.setText(this.txtNombres.getText()+" "+this.txtApellidos.getText());
            log.ingersarLog(cedula,"INGRESO EXALUMNO");
        }
        if(bandUsuario==2)
        {
            this.txtCedula.setEditable(true);
            this.cmdBuscar.setVisible(true);
            Persona per=conexion.buscarPersona(cedula);
            this.lblUsuario.setText(per.getNombres()+" "+per.getApellidos());
            
        }
        if(bandUsuario==1){
            cargarDatos(cedula);
            this.lblUsuario.setText("");
            this.cmdBuscar.setText("Volver");
        }
        
    }
    
    public void cargarDatos(String cedula) throws SQLException{
        ingresarInfoContacto(cedula);
        ingresarDatosPersonales(cedula);
        ingresarInformacionLaboral(cedula);
        ingresarInformacionAcademica(cedula);
        //ingresarInformacionEncuestas(cedula);
    }

    public void ingresarInfoContacto(String cedula) throws SQLException{
        Conexion con = new Conexion();
        
        int tipo = con.obtenerTipoContacto(cedula);
        System.out.println(tipo);
        if (tipo == 1)
        {
            txtTipo.setText("Teléfono");
        } else if (tipo == 2){
            txtTipo.setText("Correo Electronico");
        } else if (tipo == 3){
            txtTipo.setText("Otro");
        }
        Persona per = new Persona();
        Conexion conexion = new Conexion();
        String contacto = con.obtenerContacto(cedula);
        System.out.println(tipo);
        txtContacto.setText(contacto);
        
        cbxTipoContacto.removeAllItems();

        cbxTipoContacto.addItem("TELEFONO");
        cbxTipoContacto.addItem("CORREO");
        cbxTipoContacto.addItem("OTRO");
        
     
            
            per=conexion.buscarPersona(cedula);
        
        per.setCorreos(conexion.buscarCorreos(per.getCedula()));
                per.setTelefonos(conexion.buscarTelefonos(per.getCedula()));
                correos=per.getCorreos();
                telefonos=per.getTelefonos();
                
                
                    
                    DefaultTableModel temp = (DefaultTableModel) tablaCorreos1.getModel();
                    for (int i = tablaCorreos1.getRowCount() - 1; i >= 0; i--)
                    {
                        temp.removeRow(i);
                    }
                    for (int i = 0; i < correos.size(); i++) 
                    {

                            Object nuevo[] = {correos.get(i)}; //esto es por las tres columnas aunque puede variar
                
                            temp.addRow(nuevo);
                        }
                    tablaCorreos1.setModel(temp);
                    
                    
                    temp = (DefaultTableModel) tablaTelefonos1.getModel();
                    for (int i = tablaTelefonos1.getRowCount() - 1; i >= 0; i--)
                    {
                        temp.removeRow(i);
                    }
                    for (int i = 0; i < telefonos.size(); i++) 
                    {

                            Object nuevo[] = {telefonos.get(i)}; //esto es por las tres columnas aunque puede variar
                
                            temp.addRow(nuevo);
                        }
                    tablaTelefonos1.setModel(temp);
        
        String otro = conexion.ObtenerOtro(cedula);
        txtOtro.setText(otro);
        txtTPrincipal1.setText(conexion.ObtenerTelefonoPrincipal(cedula));
        txtCPrincipal1.setText(conexion.ObtenerCorreoPrincipal(cedula));
        
    }

    private void ingresarDatosPersonales(String cedula) throws SQLException {
        Conexion conexion = new Conexion();
        Persona per= new Persona();
        
        try {
            
            per=conexion.buscarPersona(cedula);
            

            if (per==null) 
            {
                JOptionPane.showMessageDialog(this, "No se encontro el exalumno con la Cedula: "+ cedula);
                this.jLabel1.setText(null);
                DefaultTableModel temp = (DefaultTableModel) tablaTelefonos.getModel();
                    for (int i = tablaTelefonos.getRowCount() - 1; i >= 0; i--)
                    {
                        temp.removeRow(i);
                    }
                    temp = (DefaultTableModel) tablaCorreos.getModel();
                    for (int i = tablaCorreos.getRowCount() - 1; i >= 0; i--)
                    {
                        temp.removeRow(i);
                    }
            }
            else
            {
                this.txtCedula.setText(cedula);
                this.txtNombres.setText(per.getNombres());
                this.txtApellidos.setText(per.getApellidos());
                this.txtDireccion.setText(per.getDireccion());
                
                per.setCorreos(conexion.buscarCorreos(per.getCedula()));
                per.setTelefonos(conexion.buscarTelefonos(per.getCedula()));
                correos=per.getCorreos();
                telefonos=per.getTelefonos();
                
                
                    
                    DefaultTableModel temp = (DefaultTableModel) tablaCorreos.getModel();
                    for (int i = tablaCorreos.getRowCount() - 1; i >= 0; i--)
                    {
                        temp.removeRow(i);
                    }
                    for (int i = 0; i < correos.size(); i++) 
                    {

                            Object nuevo[] = {correos.get(i)}; //esto es por las tres columnas aunque puede variar
                
                            temp.addRow(nuevo);
                        }
                    tablaCorreos.setModel(temp);
                    
                    
                    temp = (DefaultTableModel) tablaTelefonos.getModel();
                    for (int i = tablaTelefonos.getRowCount() - 1; i >= 0; i--)
                    {
                        temp.removeRow(i);
                    }
                    for (int i = 0; i < telefonos.size(); i++) 
                    {

                            Object nuevo[] = {telefonos.get(i)}; //esto es por las tres columnas aunque puede variar
                
                            temp.addRow(nuevo);
                        }
                    tablaTelefonos.setModel(temp);
       }

        } catch (SQLException ex) {
            Logger.getLogger("Error de conexion con la base de datos");
        }
        
        //Object uni[] = encuesta.obtenerDatos(cedula);
        String genero = conexion.obtenerGenero(cedula);
        String nacionalidad = conexion.obtenerNacionalidad(cedula);
        String raza = conexion.obtenerRaza(cedula);
        txtContraseña.setText(conexion.buscarClave(this.txtCedula.getText()));
        txtCiudad.setText(conexion.buscarCiudad(txtCedula.getText()));
        txtGenero.setText(genero);
        txtNacionalidad.setText(nacionalidad);
        txtRaza.setText(raza);
        txtTPrincipal.setText(conexion.ObtenerTelefonoPrincipal(cedula));
        txtCPrincipal.setText(conexion.ObtenerCorreoPrincipal(cedula));
        
        
        ArrayList<String> lista=conexion.listarFacultades();
        cmbCiudad.removeAllItems();   
        lista=conexion.listarCiudades();
        for (int i=0; i<lista.size();i++)
        {
            this.cmbCiudad.addItem(lista.get(i));         
            
        }

    }

    private void ingresarInformacionLaboral(String cedula) throws SQLException {
        
        Conexion conexion=new Conexion();
             
        DefaultTableModel temp = (DefaultTableModel) tablaTrabajoActual.getModel();
        for (int i = tablaTrabajoActual.getRowCount() - 1; i >= 0; i--)
           {
                        temp.removeRow(i);
           }
        try {
            tablaTrabajoActual.setModel(conexion.obtenerTrabajaActual(temp,cedula));
        } catch (SQLException ex) {
            Logger.getLogger(InterfazAdmin.class.getName()).log(Level.SEVERE, null, ex);
        }
        
        DefaultTableModel temp1 = (DefaultTableModel) tablaHistorialTrabajo.getModel();
        for (int i = tablaHistorialTrabajo.getRowCount() - 1; i >= 0; i--)
           {
                        temp1.removeRow(i);
           }
        try {
            tablaHistorialTrabajo.setModel(conexion.obtenerHistorialTrabajo(temp1,cedula));
        } catch (SQLException ex) {
            Logger.getLogger(InterfazAdmin.class.getName()).log(Level.SEVERE, null, ex);
        }
       
    }

    private void ingresarInformacionAcademica(String cedula) throws SQLException {
        Encuesta encuesta = new Encuesta();
        Exalumno per = new Exalumno();
        String info = null;
        ////////////
        /*info = encuesta.obtenerInfoAcademica(cedula);
        if (info == null){
        } else{
            txtPromedioI.setText(info.toString());
        }*/
        String info1= null;
        info1 = per.obtenerIColegio(cedula);
        if (info1 == null){
        } else {
            txtInstitucion.setText(info1.toString());
        }
        String info2= null;
        info2 = per.obtenerPromedio(cedula);
        if (info2 == null){
        } else {
            txtPromedioI.setText(info2.toString());
        }
                 
        DefaultTableModel temp = (DefaultTableModel) tablaTitulosUCuenca.getModel();
        for (int i = tablaTitulosUCuenca.getRowCount() - 1; i >= 0; i--)
           {
                        temp.removeRow(i);
           }
        try {
            
            tablaTitulosUCuenca.setModel(per.obtenerUniversidad(temp,cedula));
        } catch (SQLException ex) {
            Logger.getLogger(InterfazAdmin.class.getName()).log(Level.SEVERE, null, ex);
        }
        ///////////////
        String representante= per.obtenerRepresentante(cedula);
        ArrayList<String> lista=per.listarRepresentante();
        cbxRepresentante.removeAllItems();   
        this.cbxRepresentante.addItem("Elija un representante");
        for (int i=0; i<lista.size();i++)
        {
            this.cbxRepresentante.addItem(lista.get(i));         
            
        }
        this.cbxRepresentante.setSelectedItem(representante);
        
        DefaultTableModel temp1 = (DefaultTableModel) tablaRepresentante.getModel();
        for (int i = tablaRepresentante.getRowCount() - 1; i >= 0; i--)
           {
                        temp1.removeRow(i);
           }
        try {
            tablaRepresentante.setModel(encuesta.obtenerEstudiosRepresentante(temp1,cedula));
        } catch (SQLException ex) {
            Logger.getLogger(InterfazAdmin.class.getName()).log(Level.SEVERE, null, ex);
        }
        
            }

    private void ingresarInformacionEncuestas(String cedula) {
        
        Encuesta encuesta = new Encuesta();
         DefaultTableModel temp1 = (DefaultTableModel) tablaEncuestas.getModel();
        for (int i = tablaEncuestas.getRowCount() - 1; i >= 0; i--)
           {
                        temp1.removeRow(i);
           }
        try {
            tablaEncuestas.setModel(encuesta.obtenerEncuestas(temp1,cedula));
        } catch (SQLException ex) {
            Logger.getLogger(InterfazAdmin.class.getName()).log(Level.SEVERE, null, ex);
        }
        
        DefaultTableModel temp = (DefaultTableModel) tablaEncuestasLLenar.getModel();
        for (int i = tablaEncuestasLLenar.getRowCount() - 1; i >= 0; i--)
           {
                        temp.removeRow(i);
           }
        try {
            tablaEncuestasLLenar.setModel(encuesta.obtenerEncuestasLlenar(temp,cedula));
        } catch (SQLException ex) {
            Logger.getLogger(InterfazAdmin.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
}